NEW
Font size
WorksheetsE-R Diagram
Total questions: 20
Worksheet time: 12mins
Properties that describe the characteristics of entities are called:
entities
attributes
identifiers
relationships
Entities can be associated with one another in which of the following?
entities
attributes
identifiers
relationships
The attribute name could be structured as an attribute consisting of first name, middle name and last name. This type of attribute is called :
Simple attribute
Composite attribute
Multi-valued attribute
Derived attribute
The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is:
Single valued
Multi valued
Composite
Derived
Which of the following can be a multi-valued attribute?
Phone_number
Name
Date_of_birth
All of these
The minimum and maximum values of connectivity is called the __________ of the relationship.
cardinality
degree
modality
tuple
Who developed the E-R model?
Codd
Chen
Date
Bachman
E-R model uses which symbol for Weak entity
Rectangle
Diamond
Double rectangle
Dotted line
Which relationship is called when an association is maintained between two entities?
Unary
Binary
Ternary
n-ary
When you close a new table, it asks you for what
name of the file
where to save it
nothing
A unique identifier used in creating a table that assures there will be no duplicate data.
Primary Key
Query
Data Type
What you understand by data redundancy?
Assurance of the accuracy of data
Duplicate values in database
Security of Data
None of these
Which view of table is used to insert a field name in table.
Date sheet
Design
Database
all of the above
Which option is used to display the data in printable format in MS-Access?
Report
Query
Datesheet
Relationship
Which key is used to define relationship between 2 tables?
Candidate key
Composite key
Primary key
Secondary key
Which datatype will be used to generate numbers automatically while inserting data?
Number
Auto number
Automatic Number
Integer
