[Solved] COMP5120 Homework 1

1. A relational database consists of a collection ofa) Tablesb) Fieldsc) Recordsd) Keys2. A ________ in a table represents a relationship among a set of values.a) Columnb) Keyc) Rowd) Entry3. The term attribute refers to a ___________ of a table.a) Recordb) Columnc) Tupled) Key4. For each attribute of a relation, there is a set of permitted values, called the ________ of thatattribute.a) Domainb) Relationc) Setd) Schema5. Database __________ which is the logical design of the database, and the database _______which is a snapshot of the data in the database at a given instant in time.a) Instance, Schemab) Relation, Schemac) Relation, Domaind) Schema, Instance6. Course(course_id,sec_id,semester)Here the course_id,sec_id and semester are __________ and course is a _________a) Relations, Attributeb) Attributes, Relationc) Tuple, Relationd) Tuple, Attributes7. A domain is atomic if elements of the domain are considered to be ____________ units.a) Differentb) Indivisbilec) Constantd) Divisible8. The tuples of the relations can be of ________ order.a) Anyb) Samec) Sortedd) Constant9. Which one of the following is a set of one or more attributes taken collectively to uniquely identifya record?a) Non-key Attributesb) Sub keyc) Super keyd) Foreign key10. Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?a) NAMEb) IDc) CITYd) CITY, ID