Database Management System

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

1
DATABASE
Part A
List of entities and attributes
The entities and the attributes of the Sydney Dance Academy database has been listed
below:
Students
Student_Number
Last_Name
First_Name
Email
Phone_Number
Branch
Branch_Number
Branch_Location
Dance Style
Style_Name
Rate
Instructors
Instructor_Number
Instructor_Name
Rooms

2
DATABASE
RoomNumber
Time Table
Class_ID
Term
Week_Day
Branch_Number
Start_Time
End_Time
Instructor_Number
Style_Name
Room_Number
Enrolment
Enrolment_Number
Class_ID
Student_Number
Payment
Payment_Number
Payment_Mode
Enrolment_Number
Amount

3
DATABASE
Payment_Date
ER Diagram
Part C
Query 1
Select CONCAT (First_Name, " ",Last_Name) As StudentName, Email From student;
+-----------------+-----------------+
| StudentName | Email |