Database Questions Pg.80 Essay

Words: 929
Pages: 4
Open Document
Alex Swan
Mr. Davis
9/18/12
Homework Review Questions
3.1 Define the following terms as they apply to the relational model of data: Domain – Set of atomic (indivisible) values. Attribute – it describes a component of the database, such as a table or a field. N-tuple – in mathematics, an ordered set of n elements called its components or coordinates. Relation Schema – It is representation of database highlighting relationships that we have created. Relation State – set of tuples that have the same attributes. Degree of a relation – number of attributes n of its relation schema. Relational Database Schema – Tables, columns and relationships that make up a relational database. Relational database state – is a union of …show more content…
Values can also be not available presently. It is possible to devise different codes for different meanings of NULL values. For all these reasons, the value are generally written as NULL values in relations.
3.8 Discuss the entity integrity and referential integrity constraints. Why is each considered important? - The entity integrity constraint states that no primary key value can be NULL and is considered to be very important. This is because the primary key value is used to identify individual tuples in a relation. Having NULL values for the primary key implies that we cannot identify some tuples. - The referential integrity constraint is specified between two relations and is used to maintain the consistency among the tuples in the two relations. Informally, it states that a tuple in one relation that refers to another relation must refer to an existing tuple in that relation. Example of a referential integrity constraint is a foreign key . If the referenced relation does not exist, it will lead in an invalid state of the database. It is considered equally important.
3.9 Define foreign key. What is this concept used for? - The concept of foreign key is mainly used to identify the different relationships between relations in a Relational Database Schema. By referencing, each relation in a database schema actually links itself to other relations through the referenced relation’s primary
Show More

Related Documents: Database Questions Pg.80 Essay

Islam is the world Essay

Rel- 303 October 2, 2014 STQ Module 6 Questions: Many scholars now claim that Islam is the world's fastest growing religion, rivaling the growth of Christianity. What might be some reasons to account for this trend? “Islam is the world’s fastest-growing religion. In 1990, 935 million people were Muslims and this figure had escalated to around 1.2 billion by 2000, meaning that around one in five people follow Islam. Although the religion began in Arabia, by 2002 80% of all believers in Islam lived outside…

Words 407 - Pages 2

Alphonse Bertillon's Facial Sketches In Criminal Investigations

saw something important. In these circumstances, a sketch must be created based on the witness’ description. A sketch used in investigations can be a forensic sketch, drawn by an artist, or a composite, created by computer software (Klum et al., 2013, pg. 1). This essay documents the initial attempts at facial sketches in criminal investigations, the various roles forensic artists have filled, and America’s transition into composite sketches. Today, the majority of law enforcement agencies utilize composite…

Words 1881 - Pages 8

Teenage Pregnancy Essay

rate of 41.9% live births per 1,000 women in this age group.” Another survey from The Resource Center for Adolescent Pregnancy Prevention (ReCAPP) (2007) says “…half of all pregnancies are unintended, but among teenagers, the proportion is higher – 80 percent.” The teenage population is no longer concerned about becoming single parents. It is a normal occurrence to see a pregnant teenage girl walking around in high schools all over the United States. With teen pregnancy on the rise, so are the…

Words 2004 - Pages 9

Us Fireboming on Japan Essay

Research Question: In what ways did saturation bombing of Tokyo by the Allies in World War II affect the lifestyles of their citizens? The limits of my investigation are: * Only saturation bombing by the allies in Tokyo * Focus only on how the bombing affected the citizens financially, emotionally, and physically Methods of Research: A few methods of research for my internal assessment are: Primary sources: most of my research will come from primary sources. They will…

Words 774 - Pages 4

Abstract: Corporate Governance and Oxford University Press Essay

Question: Discuss the different methods of corporate governance of several countries Study Skills Project Peter Sin Student ID: B4000749 Table of Contents Abstract pg.3 Introduction pg.3-5 Literature Review pg.5 Hypothesis pg.5 Methodology pg.5-6 Results pg.6-9 Discussion pg.10-14 Conclusion pg.14 Reference pg.15-16 Bibliography…

Words 3628 - Pages 15

Annotated Bibliography Essay

Annotated Bibliography Shaunta Holden ENGL 111 Kevin Kliver July, 17 2015 Whitcomb, Rachael. (2011, 09}. Pot for pain? PG 64 This article it pointing out that a Seattle company is trying to make pot patches for pain control in dogs’ cats and horse’s. It also says the use of medical marijuana has gained in popularity in the last few years. A vegetarian pain management specialist says that transdermal use of marijuana could have a place in veterinarian armamentarium…

Words 1581 - Pages 7

Barbie: Communication and Discussion Board Essay

Arts, Language and Literature Division G-138 SPEECH COMMUNICATION SPCH 1311 43012 3 credit hours Fall 2013 Professor: Laura Carr Phone: (972) 860-7161 FAX (972) 860-7248 E-mail: lauracarr@dcccd.edu Office: G-112 Office Hours MWF: 11:05 a.m. - 12:05 p.m. TR: 10:50 a.m. – 11:50 a.m. Class: On-line/INET Aug. 26 to Oct 17 About this class Cooperative Learning is practiced in this learning studio. So then, what is Cooperative Learning? Cooperative Learning is a relationship…

Words 6023 - Pages 25

Winter Study Guide Essay

contains the address of the destination computer Router - an intelligent connecting device that examines each packet of data it receives and then decides which way to send it onward toward its destination. 20 million routers installed in 2002, 80 million in 2010. Topology: BUS- 1 line, so if any part is down, whole network is down. STAR- main hub, if 1 line goes down network can still operate RING- travels around until a device picks it up. Prevents collisions. Only…

Words 5237 - Pages 21

DELIA Design Document Essay

contact for questions regarding this document is: Author: Hamed Abdul Rehman Product Name: DELIA (Data Extract Load in Abacus) Phone: Ext 4348 Email: hamed.rehman@sutton.gov.uk Document Approval Document Name: DELIA (Design Document) Publication Date: Prepared by: Hamed Abdul Rehman Approved By Approval: __________________________ |Description |Pg No | |Chapter…

Words 6907 - Pages 28

Introduction To IMC Communication

1 Study Questions for written final to be given Dec. 3, 2013 9:30 – 10:45 a.m. Chapter One. An Intro to IMC Communication 1. Name the four Ps of the marketing mix: Product, price, place and promotion. 2. Which of the following is not one of the five traditional media used in promotions? a. Newspapers b. Magazines c. Social media d. Television, radio e. Billboards 3. Name two nontraditional media. Company website, Facebook, Twitter, YouTube, Instagram, Pinterest, FourSquare, 4. True/False:…

Words 4062 - Pages 17