Address weak entity
3.0 Describe the purpose of Entity- Relationship data model
Entity relationship model is a data model for representing the information of that business in an abstract way that lends itself to ultimately being implemented in a database such as a relational --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Staff: ??????????????????????????????????????????????????????????????????????????/
5.0 Cut and paste here your ER Diagram
(StudentID LONG PRIMARY KEY,
FamilyName CHAR,
PostCode INTEGER,
DateOfBirth DATETIME
Instrument table:
Contact phone table:
Student under 18 years old
Query…..
FROM Lesson
WHERE LessonDate Between Date() And Date()+7;
Students and the number of lessons they had
?????????????????????????????????????????????????????????????
Students who have never had a lesson
???????????????????????????????????????????