_______ 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
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.
_______ ensures that related data exist in parent table before allowing an entry into a child...
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...
(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 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...
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....
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...
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...
To be in the third normal form, Hint: In order to in 3NF you must first have attained 1NF and 2NF so all of the above is the correct answer. In the database design world the saying is that to be completely normalized the data be represented "by the key, the whole key, and nothing but the key so help me Codd". Ted Codd was the person behind the development of the relational theory back in the 1960s and 70s....
erms Matching Match the key terms with their definitions. Write the key term letter by the appropriate numbered definition k. Foreign key 1. Multitable query m. Nul a. AND condition b. Auto Number c. Caption property d. Cascade Delete Related Records e. Cascade Update Related fields f. Comparison Operator 8. Criteria row h. Data redundancy i. Data type 1. Field property o. OR condition p. Query q. Referential Integrity r. Simple Query Wizard 5. Wildcard Special character that can represent...
Problems and Exercises 1 through 5 are based on the class schedule 3NF relations along with some sample data in Figure 7-16. For Problems and Exercises 1 through 5, draw a Venn or ER diagram and mark it to show the data you expect your query to use to produce the results.Figure 7-16: Class scheduling relations (for Problems and Exercises 1-5Figure 7-17 Adult literacy program (for Problems and Exercises 6-14)1. Write SQL retrieval commands for each of the following queries:a....