1. ENTITY TYPES
The following are the entity types to be represented in the database:
Student, Advisor, Lease, Room, Course, NextOfKin, Staff, Invoice, Residence
2. RELATIONSHIP TYPES:
The following are the relationship types exist between the data items:
Advises: The relationship type associates Student and Advisor
Enroll: The relationship type associates Student and Course
Agree: The relationship type associates Student and Lease
Receives: The relationship type associates Student and Invoice
Has: The relationship type associates Student and NextOfKin
Rents: The relationship type associates Student and Room
Contains: The relationship type associates Residence and Room
Inspects: The relationship type associates Staff and Residence
3. DATA QUERIES
The following are some the queries which are required:
Identify the total number of the accommodated students
Identify the number of female students accommodated
Identify the number of male students accommodated
List the students and their next of kin
List students and their entering and leaving date
List students who live in halls
List students who live in flats
Identify the number of foreign students
Identify the number of Tanzanian students
List the residence and comments given in various inspections
No comments:
Post a Comment