CS8492 - DATABASE MANAGEMENT SYSTEMS (UNIT 2)

UNIT 2 - DATABASE DESIGN

15 flashcards · Computer Science · by Poongothai K

An _________ is a set of entities of the same type that share the same properties or attributes.
Entity set
Entity is a __________
Thing in real world
Not applicable condition can be represented in relation entry as A) NA B) 0 C) NULL D) Blank Space
C) NULL
Which of the following is a single valued attribute? A) Register_number B) Address C) Subject_taken D) Reference
A) Register_number
Which of the following is a multi-valued attribute? A) Phone_number B) Name C) Date_of_birth D) All of the mentioned
A) Phone_number
_________ express the number of entities to which another entity can be associated via a relationship set.
Mapping Cardinality
____________ gives a logical structure of a database graphically.
Entity-Relationship (ER) Diagram
Drop table cannot be used to drop a table referenced by a _________ constraint
Foreign Key
SELECT * FROM teachers WHERE Sec_id = 'CS-101'; Which of the following Id is selected for the following query? A) 1003 B) 1001 C) None D) Error message appears
D) Error message appears
The entity set person is classified as student and employee. This process is called ____________
Specialization
How will you select the Names whose first letter is E? A) SELECT Name FROM instructor WHERE Name LIKE 'A%; B) SELECT Name FROM course WHERE Name LIKE 'A%; C) SELECT Dept_name FROM instructor WHERE Name LIKE 'A%; D) SELECT Name FROM instructor WHERE Dept_name LIKE 'A%;
A) SELECT Name FROM instructor WHERE Name LIKE 'A%;
If a relation is in BCNF, then it is also in A) 1NF B) 2NF C) 3NF D) All of the mentioned
D) All of the mentioned
Which one is based on multi-valued dependency? A) First B) Second C) Third D) Fourth
D) Fourth
The term for information that describes what type of data is available in database is
Metadata
A domain is __________ if elements of the domain are considered to be indivisible units
Atomic