CS403P Quiz by Iqra Azhar

which of the following attribute is most suitable for Primary Key

Roll No., NAME, DATE_OF_BIRTH ADDRESS , " Roll No."

A specific record of a relation is accessed through:

Arbitrary Key Random key Primary Key Secondry Key Primary Key

In relational database, each cell of a table cannot have __________ .

Numeric values String values Multiple values Unique values

A manufacturer manufactures 100 motor bikes in a month. The relationship between manufacturer and motor bikes is Many to many

one-to-many relationship.

What is the basic component/structure of Relational Data Model?

Tuple Relation Model Schema Relation

In the first semester of a degree program in a university, each student has to study five pre-selected courses. The relationship between student and course is:S elect the correct option

Many to many

Many to many.

Consider the following two sets :STD Name = [Ali, Hassan]Course Name = {Eng, Math, Phy} Then the Cartesian product of STD Name and Course Name (i.e. STD Name x Course Name) will be equal to:

{(Ali, Eng), (Hassan, Math), (Ali, Phy), (Hassan, Eng), (Hassan, Math), (Hassan, Phy)} {(Ali, Math), (Ali, Phy), (Hassan, Phy), (Hassan, Eng), (Hassan, Math), (Hassan, Phy)} {(Ali, Eng), (Ali, Math), (Ali, Phy), (Hassan, Eng), (Hassan, Math), (Hassan, Phy)} {(Ali, Eng), (Ali, Math), (Ali, Phy), (Hassan, Phy), (Ali, Math), (Hassan, Eng)} {(Ali, Eng),(Ali, Math),(Ali, Phy),(Hassan, Eng),(Hassan, Math),(Hassan, Phy)}

Which of the two data models were used before the relational data model?

Network and Object Oriented Data Mode lFlat Data model and Hierarchical Data Model Hierarchical and Network Data Model Object Oriented and Flat Data Model Hierarchical and Network Data Model

Consider the following two sets:X = [a, b]Y = {1,3,5}Then the Cartesian product of A and B (i.e. XxY) will be equal to

{(a, a), (a,3), (a,1), (b,5), (b,5), (b,3)} {(a,1), (a,3), (a,5), (b,1), (b,3), (b,5)} {(a,1), (b,1), (a,5), (b,3), (a,5), (b,5)} {(a,1), (a,5), (a,3), (b,5), (b,1), (b,5)} Therefore, the correct option is: {(a,1),(a,3),(a,5),(b,1),(b,3),(b,5)}

If a teacher teaches multiple courses in a university then the relationship between teacher and course is:Select the correct option