Computer System

ERD Tutorials 1 Small College Database Draw an entity matrix and an ERD for a tenuous college database comprising the entity types: DEPARTMENT, COURSE, STUDENT and LECTURER. to from each angiotensin-converting enzyme one department has many readers. A lecturer belongs to only mavin department. Each department offers many varied courses, and many lecturers feces teach on a single course. Lecturers can also teach on more than one course. A student whitethorn enrol for many courses offered by different departments. 2 Local Education Authority (LEA) A local education authority (LEA) requires a system to train details of the applicants who apply for courses run by local colleges. Each course is run at only one college, though more than one course is run at each college. An applicant may apply for several(prenominal) courses. Details ar to be kept of the standard qualifications that the majority of applicants realise, such as GCSEs. Draw an entity matrix and ERD for this system. 3 The Bus Company A verdant lot company owns a number of buses. Each bus is allocated to a particular route, although some routes may have several buses. Each route is made up of several stages which can passes through a number of towns. A town may be situated along several stages (of different routes of course).

ace or more drivers are allocated to each stage of a route. Prepare an entity matrix and an ERD for this scenario. 4 Student Enrolment A college has a student enrolment system. Each student is enrolled on one course. The students choose which modules they wish to field of force. Students from several courses may choose to study the same module. A course will typically have several modules, and an individual module may be offered on several different courses. Requirements of the system include the ability to rig which students are enrolled on a particular course and which modules a student has chosen to study; on which course a module may be studied; which modules are offered by a particular course.... If you want to get a plentiful essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper