DBMS-Basic concepts

The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called

• composite

• structured

• multi valued

• derived

check the incorrect option

• ER is an conceptual Data model

• DBMS avoids Data redundancy

• we cannot create a table without a primary key

• An attribute of an entity can have more than one value

The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is

for the following two entities which one is the correct option CUTOMER/ORDER

• one to one

• one to many

• many to one

For the following two entities which is the correct option RULER/COUNTRY

• one to many

• one to one

• many to one

Record in a database is

• can have information about a person

• Known as row

• group of related record

• Known as column

for the following two entities which is appropriate relationship Zoo/Animal

• one to one

• one to many

• many to one

Entity-relationship diagrams is

• a tool that graphically shows the collections of entities in a system

• a tool that graphically shows the connections among entities in a system

Identify the primary key from the following

• name

• mark

• telephone number

• Gender

can a primary key be null

• yes

• no