WorksheetsCPO Lesson 1.1
Total questions: 18
Worksheet time: 9mins
What level of abstraction was defined by this statement:
Data presented to the end user
(a)
What level of abstraction was defined by this statement:
How data is stored on disk
(a)
What level of abstraction was defined by this statement:
Data types, relations between data items and constraints on the data
(a)
Check the DBMSes in the list
MongoDB
PostgreSQL
Redis
MySQL
Microsoft Excel
File system storage is a good alternative to using a DBMS
True
False
For the acronym ACID, what does A stand for?
(a)
For the acronym ACID, what does C stand for?
(a)
For the acronym ACID, what does I stand for?
(a)
For the acronym ACID, what does D stand for?
(a)
Which of these problems does a DBMS help solve?
Need for ad-hoc system to use the data
Data duplication
Resource locking (one user at a time only)
Human error
Bad quality data
What will an attribute (ER model) become in the relational model?
An attribute
A relation
A foreign key in a relation
What will an entity (ER model) become in the relational model?
An attribute
A relation
A foreign key in a relation
What will a relationship with a 0:1 or 1:1 cardinality (ER model) become in the relational model?
An attribute
A relation
A foreign key in a relation
What will a relationship with a 0:n or 1:n cardinality (ER model) become in the relational model?
An attribute
A relation
A foreign key in a relation
The surname attribute is a good choice for a primary key in a Person entity or relation?
True
False
This is a correct ER diagram.
True
False
In what year did Codd propose the relational model?
(a)
Select the properties necessary to be a primary key
Be of minimal size
Change value with time
Reference another relation
Have a unique value for each tuple
