Database for Desklib - Entities, Attributes, ER Diagram, Tables, Queries

Running head: DATABASE
Database
Name of the student:
Name of the University:
Author Note

1
DATABASE
Part A
List of entities and attributes
The list of entities for the database are provided below:
 Student
 Branch
 Dance Style
 Instructors
 Time Table
 Rooms
 Enrolment
 Payment
The list of attributes of entities for tables in the database are provided below:
Students
StudentID
LastName
FirstName
Address
Branch
BranchID
BranchLocation
Dance Style

2
DATABASE
StyleID
StyleName
Instructors
InstructorID
InstructorName
Rooms
RoomNumber
Time Table
TimeID
Term
DayOfWeek
BranchID
StartTime
EndTime
RoomNumber
Enrolment
EnrolmentID
TimeID
StudentID
Payment

3
DATABASE
PaymentID
EnrolmentID
Amount
ER Diagram
Part B
Database Tables
Student