Database Management System
Week 1 - Tutorial
1. A database is collection of __________ related data
a. Logically
b. Physically
c. Not
d. badly
2. One disadvantage of the file processing systems is:
a. reduced data duplication
b. program-data independence
c. limited data sharing
d. enforcement of integrity constraints
3. Each column in a table represents a(n) ____________ of an entity.
a. Description
b. Attribute
c. Byte
d. logical element
4. Which of the following is NOT an advantage of database systems?
a. redundant data
b. program data independence
c. better data quality
d. reduced program maintenance
5. Databases may be more expensive to maintain that files because of:
a. the need for specialized personal
b. the complexity of the database environment
c. backup and recovery needs
d. all of the above
6. Which of the following is software that is used to create, maintain and
provide controlled access to database?
a. Network operating system
b. User view
c. Database management system
d. Attribute
7. An attribute or attributes that uniquely identify each row in a relation is called
a:
a. Column
b. Foreign key
c. Primary key
d. Duplicate key
8. An attribute in a relation that serves as the primary key of another relation in
the same database is called a:
a. Primary key
b. Foreign key (or Candidate key or secondary key)
c. Foreign row
d. Link key
9. A logical grouping of characters is a:
a. Character
b. Field
c. Record
d. File
10.A single row in a relation is called a(n):
a. Attribute
b. Domain
c. Field
d. Tuple
Question 1
CJ Software Ltd is presently creating databases in MS Access, as the database administrator
advice the management why they should stop using the above database and choose one of the big
three (3) commercial databases. In your advice compare/contrast the big 3 commercial databases
similarities and differences
Rules of relation
1. Relation (fle, table) is a two-dimensional table
2. Attributes (field or data item) is a column in the table
3. Each column in the table has unique name within that table
4. Each column is homogenous, thus the entries in any column are all of the same type
5. A tuple (i.e. record) is a row in the table
6. The order of the rows and columns is not important
7. Duplicate rows are not allowed (candidate keys are designed to prevent this)
Question 2
Use the data below to:
- Identity a primary key
Employee_number
- Identity Foreign Key
Department_number
- Produce a RDBMS schema
Relation
Employee Department
Emp_num (primary) Emp_num
Emp_Fname
Employee Number, Employee FirstName, Department_number, Employee Last Name,
Department name, Salary
Question 3
Data Hierarchy refers to the systematic organization of data. Outline with use of a diagram the
hierarchy of data. Give an example of each level of the data hierarchy.
Logical Organisation of data
Bit
Byte
Field (or attributes) relational database
Record or (tuples)
File
Database
Question 4
Define the following terms:
• Data Redundancy
Duplications of data
• Data Integrity
Data is entered correctly
Question 5
Define the term database.
An organised collection of data
What are advantages and disadvantages of DBMS vsFile System
DBMS File system
Outline the components of a database system.
Software - DBMS
Users
- Database Administrator
- End users
- Database designer
- Database application programmer
Hardware
Data
Database
Email: portmoreamis@yahoo.com
Password: mustpass
