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:

1. Student under 18 years old

Query…..

FROM Lesson

WHERE LessonDate Between Date() And Date()+7;

4. Students and the number of lessons they had

?????????????????????????????????????????????????????????????

6. Students who have never had a lesson

???????????????????????????????????????????