Font size
WorksheetsDBMS-Basic concepts
Total questions: 10
Worksheet time: 5mins
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
(a)
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
