A database is to be designed for a college to monitor students' progress throughout their course of study. The students are studying for a degree (such as BA, M.Sc., etc.) within the framework of the modular system. The college provides a number of modules, each being characterized by its code, title, and credit value, module leader, teaching staff and the department they come from. A module is coordinated 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. Students are free to choose any module they wish but the following rules must be observed: some modules require prerequisites modules and some degree programs have compulsory modules. The database is also to contain some information about students including their numbers, names, addresses, degrees they study for, and their past performance (i.e. modules taken and examination results). Draw an ER diagram for this database using as much of the ER model as appropriate.

A database is to be designed for a college to monitor students' progress throughout their course of study. The students are studying for a degree (such as BA, M.Sc., etc.) within the framework of the modular system. The college provides a number of modules, each being characterized by its code, title, and credit value, module leader, teaching staff and the department they come from. A module is coordinated 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. Students are free to choose any module they wish but the following rules must be observed: some modules require prerequisites modules and some degree programs have compulsory modules. The database is also to contain some information about students including their numbers, names, addresses, degrees they study for, and their past performance (i.e. modules taken and examination results). Draw an ER diagram for this database using as much of the ER model as appropriate.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 5HOA: Access path A database table is composed of records and fields hold data. Data is stored in records....

See similar textbooks

Similar questions

A database is to be designed for a college to monitor students’ progress throughout their course of study. The students are studying for a degree (such as BA, M.Sc., etc.) within the framework of the modular system. The college provides a number of modules, each being characterized by its code, title, and credit value, module leader, teaching staff and the department they come from. A module is coordinated 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. Students are free to choose any module they wish but the following rules must be observed: some modules require prerequisites modules and some degree programs have compulsory modules. The database is also to contain some information about students including their numbers, names, addresses, degrees they study for, and their past performance (i.e. modules taken and examination results).Draw an ER diagram for this database using as much of the…
Access path A database table is composed of records and fields hold data. Data is stored in records. A field is a part of a record and contains a single piece of data for the subject of the record. The access path for finding the list of books is AUTHOR: AuthorID, Lname BOOKAUTHOR: AuthorID, ISBN BOOKS: Pubdate, ISBN
Program isolation, multiple user support and the usage of catalogs are all aspects of a database design that falls within this category.
1-doctor system clinic 2-patient 3-pharmacy 4-blood bank 5-doctor appointment Each part of the system must be connected to each other so the system has a central database role inside the system 1-doctor 2-assistant 3-admin 4-pharmacy 5-blood bank donator
Database Management Jill Bill Marketplace is a business located in Florida. Within the JBM compound, you can purchase many types of products that are related to a specific category, for example, books or antiques. JBN does not own any of the stalls that sell products, rather they rent them out to small vendors. Each vendor has to pay a monthly fee to use the Marketplace. JBM products are available to different customers who sell their products daily. Each category type (e.g. books ) is managed by a particular supervisor. A customer will order their selected product in terms of the amount from that vendor, who is also free to apply discounts on any product in his store. Other than category supervisors there are other staff that manages different departments in the mall, but they all report to two marketplace managers. The small vendors will report to the category managers on the nature of their stock and if and when restocking is required. All category managers report to the third…
DATABASE MANAGEMENT Design an EER diagram for a database used to manage a racket sport association (for example, US Tennis Association). The following is a list of simplified requirements. Each member of the sport association has an id, a name, sex, age, an address, a phone number. A member can be a player, an umpire (i.e., referee), a coach, or an officer (i.e. a member can belong to one or more of the above categories). An umpire has a type (i.e., national, international, etc.). A coach has a certificate (i.e., level I, II, etc.). An officer has an office (i.e., a room number such as 101 or 212 in the main building). Each club has a name, an address, an owner, and a phone number. Except for some officers, every member belongs to one or more clubs (Hint: Make relationships between the subclasses of “member” and club). A player can be a professional or an amateur (but not both). A professional player has a rank (such as 1, 2, etc. within the association), and a coach (Note: Every…
System Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The data stored regarding each member of staff includes staff number, name, address,…
A database has student records, with four different options for grade level: 9th, 10th, 11th, or 12th. What are two different ways that you could write a query that would locate all students who are not in 11th grade? Which method would you prefer? Why?
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) MSc, etc.) within the framework of a modular system. The college provides a number of modules, each being characterized by a code, title, and a credit value. A module belongs to one department and is co-ordinated 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 include his/her IDNO, Name which is comprised of a surname and first name, Address {StrNo, Zip Code, City} and they 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 code, name. Student are free to choose any module they wish but can’t do more than five and less than three and; a module can only be taught if it has more than ten…
System Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The data stored regarding each member of staff includes staff number, name, address,…
System Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The data stored regarding each member of staff includes staff number, name, address,…
Each department runs a number of courses. The university provides a set of modules used in different courses. Each course uses a number of modules but not every module is used. A course is assigned a unique course code and a module is identified by a unique module code. A module can be used in one course only, but can be studied by many students. In addition to the module code each module unique title, start date, end date, texts (books), and assessment scheme (i.e., coursework and exam marks percentages) are also stored. Each course is managed by a member of academic staff, and each module is coordinated by a member of academic staff also. The database should also store each course unique title, and duration (in years). A student can enroll in one course at a time. Once enrolled a student is assigned a unique matriculation number. To complete a course, each student must undertake and pass all the required modules in his/her course. This requires that the database store the…