_______ ensures that related data exist in parent table before allowing an entry into a child...
_______ ensures that related data exist in parent table before allowing an entry into a child table.
A. SQL
B. Data redundancy
C. Data Integrity
D. Referential integrity
Homework Answers
Answer:
Correct answer is:
D. Referential integrity
Explanation:
Referential integrity ensures all references are valid. It ensures that related data exist in parent table before allowing an entry into a child table.
SQL is structured query language.
Data redundancy means there are data in tables which are repeated.
Option D is most appropriate and other options A, B and C are incorrect.
Add Answer to:
_______ ensures that related data exist in parent table before
allowing an entry into a child...
Referential integrity constraints should disallow adding a new row to a child table when the foreign...
Referential integrity constraints should disallow adding a new row to a child table when the foreign key does not match a primary key value in the parent table. True or False All database applications send and receive database data by sending SQL statements to the DBMS. True or False A candidate key is a combination of one or more columns that is used to identify particular records in a table. True or False Which of the following is a candidate...
Which of the following describes referential integrity? A. A Primary Key of a relational table must...
Which of the following describes referential integrity? A. A Primary Key of a relational table must not contain a null value B. One fact must not be in multiple places C. The value for a foreign key attribute must either be null or match the one of the data value of that attribute in the table in which the attribute is a primary key D. Referential Integrity is a principle that prevents the use of redundancy, avoids null values and...
Assume that The Queen Anne Curiosity Shop designs a database with the following tables. CUSTOMER (CustomerID,...
Assume that The Queen Anne Curiosity Shop designs a database with the following tables. CUSTOMER (CustomerID, LastName, FirstName, EmailAddress, EncyptedPassword, City, State, ZIP, Phone, ReferredBy) EMPLOYEE (EmployeeID, LastName, FirstName, Position, Supervisor, OfficePhone, EmailAddress) VENDOR (VendorID, CompanyName, ContactLastName, ContactFirstName, Address, City, State, ZIP, Phone, Fax, EmailAddress) ITEM (ItemID, ItemDescription, PurchaseDate, ItemCost, ItemPrice, VendorID) SALE (SaleID, CustomerID, EmployeeID, SaleDate, SubTotal, Tax, Total) SALE_ITEM (SaleID, SaleItemID, ItemID, ItemPrice) The referential integrity constraints are: ReferredBy in CUSTOMER must exist in CustomerID in CUSTOMER Supervisor...
(CO 6) The benefit of a relationship is to A. efficiently combine data from related tables....
(CO 6) The benefit of a relationship is to A. efficiently combine data from related tables. B. facilitate how Access will manage the relationship. C. determine which fields to include in each table. D. minimize data redundancy.
Hi good day i need homework help fast please d32 1./What is the maximum length that...
Hi
good day i need homework help fast please
d32 1./What is the maximum length that a VARCHAR data type can be: a. 65535 b. 1023 C. 255 d. 32767 2.) Why are alias' used for table and columns? a. to make the names easier to understand b. to hide the column or table c. to be able to remove them from the database d. to give the appearance that they are new- 3.)What does the FIELD function allow you...
8 decay Before B decay Before After After V. Parent Daughter Parent Daughter nen AP →...
8 decay Before B decay Before After After V. Parent Daughter Parent Daughter nen AP → D+e+v P-D + entry electron neutrino Anti- decay A cobalt Co nucleus (27 protons, 60 nucleons) go through a decay. (a) Find the number of protons and the number of nucleons in the Daughter nucleus. Enter the number of protons in the first box, and number of nucleons in the 2nd box. Enter a number Submit (5 attempts remaining) Enter a number Submit (5...
Question 11 A table is in _____ if it does not contain a repeating group. a....
Question 11 A table is in _____ if it does not contain a repeating group. a. fourth normal form b. second normal form c. first normal form d. third normal form 1 points Question 12 One type of validity check, called _____, is a set of rules that avoids data inconsistency and quality problems. a. combinatorial integrity b. candidate integrity c. foreign integrity d. referential integrity 1 points Question 13 A common method of cardinality notation is called _____ because...
an int's che the hein awam damp cloth MLA before the stick Swedding the int Have...
an int's che the hein awam damp cloth MLA before the stick Swedding the int Have the infant de non-nutrite sucking E Do the stick while the infantis asleep 46. A child on the nurse's floor is having a polysomnogram. The parent wants to know what types of data are obtained from the sleep study. The nurse knows that which data can be provided? Select all that apply. A Heart rate and respirations B. Brain waves C. Eye and body...
This is questions of Accounting Information Systems 1) Fo a database. Each row in this spreadsheet...
This is questions of Accounting Information Systems
1) Fo a database. Each row in this spreadsheet represents a: ur Tet Industries tracks customer information using various Microsoft Excel spreadsheets stored in a. Field b. Record c. File d. Database 2) A d tables is a. What is the correct term for the database field in Table 1? latabase field in Table 1 that serves as a unique identifier in Table 2 and is used to link both of the a....
coould someone help me with these questions 1. A child class that is a specialization of...
coould someone help me with these questions
1. A child class that is a specialization of the parent dlass is said to have an "is-a" relationship. True or False A variable must be created with assignment statement before it can be used in an expression. 2. True or false When using inheritance to define a new class, the new class is called a 3. a. subclass b. child class c. derived class d. all of the above method must be...
Hi
good day i need homework help fast please
d32 1./What is the maximum length that a VARCHAR data type can be: a. 65535 b. 1023 C. 255 d. 32767 2.) Why are alias' used for table and columns? a. to make the names easier to understand b. to hide the column or table c. to be able to remove them from the database d. to give the appearance that they are new- 3.)What does the FIELD function allow you...
8 decay Before B decay Before After After V. Parent Daughter Parent Daughter nen AP → D+e+v P-D + entry electron neutrino Anti- decay A cobalt Co nucleus (27 protons, 60 nucleons) go through a decay. (a) Find the number of protons and the number of nucleons in the Daughter nucleus. Enter the number of protons in the first box, and number of nucleons in the 2nd box. Enter a number Submit (5 attempts remaining) Enter a number Submit (5...
an int's che the hein awam damp cloth MLA before the stick Swedding the int Have the infant de non-nutrite sucking E Do the stick while the infantis asleep 46. A child on the nurse's floor is having a polysomnogram. The parent wants to know what types of data are obtained from the sleep study. The nurse knows that which data can be provided? Select all that apply. A Heart rate and respirations B. Brain waves C. Eye and body...
This is questions of Accounting Information Systems
1) Fo a database. Each row in this spreadsheet represents a: ur Tet Industries tracks customer information using various Microsoft Excel spreadsheets stored in a. Field b. Record c. File d. Database 2) A d tables is a. What is the correct term for the database field in Table 1? latabase field in Table 1 that serves as a unique identifier in Table 2 and is used to link both of the a....
coould someone help me with these questions
1. A child class that is a specialization of the parent dlass is said to have an "is-a" relationship. True or False A variable must be created with assignment statement before it can be used in an expression. 2. True or false When using inheritance to define a new class, the new class is called a 3. a. subclass b. child class c. derived class d. all of the above method must be...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago