psht A- Multiple choice (1 Mark each) 20 Marks Circle the letter (a, b, c, d) of
ID: 3836574 • Letter: P
Question
psht A- Multiple choice (1 Mark each) 20 Marks Circle the letter (a, b, c, d) of the correct answer from the list provided. 1. Within a table, the primary key must be unique so that is will identify each row. When this is the case, the table is said to exhibit ntegrity. a) referential b) entity c) enforced d) key 2. which of the following should be a derived attribute? a) Person's last name b) Person's age c) Person's social insurance number d) Person's phone number makes a file system extremely cumbersome from a programming and data management perspective. a) Data independence b) Data dependence c) Structural independence d) Logical data format expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity a) Connectivity b) Relationship c) Dependence d) Cardinality attribute fro 5. One important inheritance characteristic is that all entity subtypes inherit their their supertype. a) primary key b) secondary key c) foreign key d) composite key 6. The Entity Relationship Diagram is used to graphically represent the database model. a) condensed b) physical c) logical d) conceptualExplanation / Answer
As per Chegg policy, I'm uploading answer of first 4 questions:
1.) Whenever we have a primary key in a table, it is said to be exhibit key integrity. Hence, option d is correct.
2.) Person's age can be derived from person's dob and today's date. Hence, option b is correct.
3.) Structural Independence makes a file system cumbersome from a programming and data management perspective. Hence option c is correct.
4.) Cardinality represents the min and max no. of entities in a relation. Hence, option d is correct.
5.) I'm not sure about this answer but I will go with primary key. So, according to me, option a is correct.
Hope it helps, do give your valuable response.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.