In most colleges and universities such as SJSU, which of the following functiona

Question

In most colleges and universities such as SJSU, which of the following functional dependence is valid (c) Instructor-Last-Name-) Instructor-ID | (a) Student-ID Grade (d) none of the above 14 (b) Instructor-ID Class-Code A well-designed relational database table usually has many multi-valued columns 15 (a) true (b) false 16 Can a foreign key column contain duplicate values? (a) yes (b) no 17 (a) yes (b) no 18 (a) yes (b) no 19 (a) true (b) false 20 and character data type in the same column? (a) yes (b) no Can a relational database table have two foreign key columns? Can a relational database table have two primary keys? In a relational database table, the primary key column must always be the first column In a relational database table, can a column have data of two different data types such as integer data

Explanation / Answer

14) C . Instrctor ID is uniqe value. we can easily found out Instructor Name by using Instructor ID.

15) FALSE. NO its not possible. If Multi value presents then Its not Normalized.

16) YES. Foreign key can be duplicate values.

17) YES. It is possible that we can use multiple foreign key in same table.

18) NO. we cant use more than one primary key in same Table.

19) False. its not mandetory that primary key should present in first column.

20) NO. its not possible! you can use only one data type per column.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.