A database is to be designed for a college to monitor students' progress throughout their course of
Fantastic news! We've Found the answer you've been seeking!
Question:
- A database is to be designed for a college to monitor students' progress throughout their course of study. The students are pursuing a degree (such as BA, BA (Hons), etc) within the framework of a modular system. The college provides a number of modules, each being characterized by a code, title, and credit value. a module belongs to one department and is characterized by a module leader who shares teaching duties with one or more lecturers. A lecturer may teach ( and be a module leader for ) more than one module. Information about a lecturer includes his or her ID number, name, which is comprised of surname and first name, address (Str no, zip code, city ), and are required to have at least two phone numbers. Every lecturer belongs to a given department, and a department hosts at least two modules. Each department has a name and a code. students are free to choose any module they wish but can't do more than five and less than three; a module can only be taught if it has more than ten students. Information about students includes their numbers, names, address, and degree they are pursuing. their past performance i.e. examination grade for each module is graded.
- Required: Use the scenario above to Draw an ER diagram for this database using as much of the ER model as appropriate.
Related Book For
Posted Date: