Create an ER Diagram for the following scenario. Please state any assumptions you have made in your answer. A university offers a Mathematics program. This program can offer any amount of courses in a semester. Each course has a roster limit, location and time slot. A student can be registered for any number of courses in a semester but to register for a course they must have a valid student ID and address. Each course is assigned a single professor. Only on completion of a course, a student receives a final grade for that course.

Create an ER Diagram for the following scenario. Please state any assumptions you have made in your answer. A university offers a Mathematics program. This program can offer any amount of courses in a semester. Each course has a roster limit, location and time slot. A student can be registered for any number of courses in a semester but to register for a course they must have a valid student ID and address. Each course is assigned a single professor. Only on completion of a course, a student receives a final grade for that course.

Operations Research : Applications and Algorithms

4th Edition

ISBN:9780534380588

Author:Wayne L. Winston

Publisher:Wayne L. Winston

Chapter8: Network Models

Section8.5: Minimum-cost Network Flow Problems

Problem 8P

See similar textbooks

Similar questions

A company has various rules for how payments to suppliers are to be authorized.Some payments are in response to an approved purchase order. For approved purchase orders under $5,000, the accountingclerk can immediately issue a check againstthat purchase order and sign the check. Forapproved purchase orders between $5,000and $10,000, the accounting clerk can immediately issue a check but must additionallyobtain a second signature. Payments for approved purchase orders over $10,000 alwaysrequire the approval of the accounting manager to issue the check as well as the signature of two accounting clerks. Payments thatare not covered by a purchase order that areunder $5,000 must be approved by the accounting manager and a departmental manager who will absorb the cost of the paymentinto that department’s budget. Such checkscan be signed by a single accounting clerk.Payments that are not covered by a purchaseorder that are between $5,000 and $10,000must be approved by the accounting…
A library has books, journals, and periodicals that it loans to its users. All library material has an accession number which is a unique identifier and a price. In addition, a book has a title, publisher, year of publication, edition, and authors. Journals have journal name, volume number, issue number and year of publication. Each article in a journal has a title and authors. A periodical has a name and date of publication. The library keeps one or more copies of each library item (book, journal, periodical). Copies of all library material can be loaned to users. Reference-only material is loaned for 2hrs and can’t be removed from the library. Other material can be loaned for 2 weeks. For every loan, the library records the user, the loan date and time, and the return date and time. For users, the library keeps their name, address, and cell phone number. If a user loses a loaned item they are made to purchase it, however, if the user delays with the loaned item they are finned…
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…
Luxury-Oriented Scenic Tours (LOST) provides guided tours to groups of visitors to the Washington, D.C. area. In recent years, LOST has grown quickly and is having difficulty keeping up with all of the various information needs of the company. The company's operations are as follows: LOST offers many different tours. For each tour, the tour name, approximate length (in hours), and fee charged is needed. Guides are identified by an employee ID, but the system should also record a guide's name, home address, and date of hire. Guides take a test to be qualified to lead specific tours. It is important to know which guides are qualified to lead which tours and the date that they completed the qualification test for each tour. A guide may be qualified to lead many different tours. A tour can have many different qualified guides. New guides may or may not be qualified to lead any tours, just as a new tour may or may not have any qualified guides. Every tour must be designed to visit at least…
Exercise 3: school system Each subject is owned by a department and each department is managed by a teacher, called Head of Department (HOD). Each department has a name and a unique code number. Each subject has a name, unique number and credit value. All teachers have a unique ID. A HOD cannot manage more than one department at a time. Also, a HOD does not teach subjects. A subject cannot be taught by more than one teacher. Finally, the system needs to know each student's contact details, including, full ID, address, age and gender, as well as date of enrolment in the subject. name, student
Draw a complete ER-diagram for the following case. A lecturer (having an ID, name and room number) is responsible for organizing a number of course modules. Each module has a unique code and also a name and each module can involve a number of lectures who deliver part of it. A module is composed of a series of lectures and sometimes lectures a on a given topic can be part of more than one module. A lecture has a time room and date and is delivered by a lecturer and a lecturer may deliver more than one lecture. Students, identified by number and name, can attend lectures and a student must be registered for a number of modules. We also store the date on which the student first registered for that module. Finally, a lecturer acts as a tutor for a number of students and each student has only one tutor. Also show relational database schema including Primary and Foreign key constraints. (Please draw this on a paper)
An art museum owns a large volume of works of art. Each work of art is described by an item code (identifier), title, type, and size; size is further composed of height, width, and weight. A work of art is developed by an artist, but the artist for some works is unknown. An artist is described by an artist ID (identifier), name, date of birth, and date of death (which is null for still living artists). Only data about artists for works currently owned by the museum are kept in the database. At any point in time, a work of art is either on display at the museum, held in storage, away from the museum as part of a traveling show, or on loan to another gallery. If on display at the museum, a work of art is also described by its location within the museum. A traveling show is described by a show ID (identifier), the city in which the show is currently appearing, and the start and end dates of the show. Many of the museum works may be part of a given show, and onlyactive shows with at least…
In material System analysis and design
Draw the ER diagram of the following requirements: A City Hall wants to manage the members of its entertainment centers. Each center has an address, a district, a unique name. Each center offers several animations. An animation is provided by only one center. Each animation has a unique name and semi-annual cost. A member has a unique id, name (first, middle, last), several contact phone numbers and an address. A member may enroll only in one center and the date of registration is maintained. The member can practice many animation activities.
In olympic games, there are two types of persons involved i.e. staff and athletes. They have id, name, address, and date of birth. In addition to these details, staff has job title and salary while athlete has a category and visa information. Staff has a qualification type which can be verified, if needed. There are multiple games played at Olympics. Every game has a name, date, and time. Games are played at the venues that has name, address, and capacity. Athlete participants in the scheduled games by registering themselves. Write the java software that will manage the Olympics. Your program must contain the following: Inheritance Polymorphic processing for printing relevant information identification of relevant states and methods. Aggregation or composition. Interface You can implement in whatever way you want which is satisfying the given requirements.
There are a limited number of repair services that PEAR can perform. Foreach repair service, there is a service ID number, description, and charge.“Charge” is how much the customer is charged for the shop to perform theservice, including any parts used. The actual repair of a device is theperformance of the services necessary to address the problems described bythe customer. Completing a repair request may require the performance ofmany services. Each service can be performed many different times duringthe repair of different devices, but each service will be performed only onceduring a given repair request.
draw the er diagram and label