Year 12s: what will be the first way you research your future options? >>

Need Help on Erd Modelling 2nd year computer science (module is database)

Erd Modelling

A school has decided to promote itsstudents’ health by encouraging them all to take part in some form of physicalactivity. This could be a sport, dance,or some other form of exercise such as aerobics. A database is required to manage theactivities and produce reports on student attendance.

Basic student data such as their name, dateof birth and gender will be held on this new ‘Activities Database’. Each activity to be offered will have a nameand description, and will have one or more coaches that are qualified to teachit. The name and mobile number of eachcoach will be kept, along with the date on which they qualified to teach eachactivity that they are qualified for and notes on the experience they have hadof teaching it. Each student will beasked to express a preference for at least two activities and these preferenceswill be recorded together with the student’s level (beginner, some experience,advanced) for each preference.

I want to know the ERD modelling for the question and i would also be able to display (student/s that is undertaking which activity and which coach is teaching a particular activity)

Quick Reply

Related discussions

Latest

Articles for you

Your guide to handling revision and exam stress

Making a revision timetable that actually works

Support at university: students describe where to find help

First and insurance university choices explained