Draw an EER diagram for the following situation: City Transportation Authority needs to keep track of the traffic through and the toll revenues collected from the toll bridges, tunnels, and road toll stops (all of these are toll collection points) managed by the authority. Each toll collection point has a unique name. Toll collection point data that should be maintained are a description, the day operations started at the collection point, and location coordinates. Each toll collection point has a number of toll booths identified by a toll booth number, some of which are manned and some unmanned (using the city's QuickLane collection system). The city wants to separately track passenger vehicles, trucks, buses, and motorcycles. Each of these categories has a different toll amount at each toll collection point. At the vehicle level, only those vehicles using the QuickLane system can be identified with their license plate number; the make and model of each vehicle are also maintained in the
Want to see the full answer?
Check out a sample textbook solutionChapter 3 Solutions
MODERN DATABASE MGMT.(PEARSON CHANNEL)
- A college offers correspondence courses to students. Each course lasts 20 weeks and is based on a weekly study module and progress test. At the end of the course students sit an invigilated examination. The college Registrar deals with enquiries and applications, and students applying who have sufficient qualifications are asked to register by completing and submitting an application form. After approval by the Academic Director, the application form is returned to the Registrar who creates a student file. The Accounts department receive the application form and using information from the student file creates an invoice that is sent to the student. Payments made are registered on the invoice file. The first batch of student material and tests is issued from the library only to students who have paid fees (this information is taken from the invoice file). Progress tests are marked by academic staff and the results, together with comments, are sent out with next week’s study block. The…arrow_forwardAn E-learning website needs your help to design its database. They need to store information about teachers and online tutorials. Each teacher has a unique ID, name, and at least one field of specialty. Teachers form groups to prepare online tutorials. Each group has unique name and at least one teacher as a member. Each online tutorial has a title, date and organized by exactly one group. The title of the tutorial is unique for the group. Each tutorial consists of several sessions, described by their titles and durations. Naturally, each session is presented by one teacher and belongs to exactly one tutorial. In addition, sessions on the same tutorial have different titles. Design an ERD for this application. Note any unspecified requirements, and make appropriate assumptions to make the specification complete.arrow_forwardAn organization has many departments through-out the country. Data held on each department is id, location and phone number. Id is used to uniquely identify a department. A department has one or more than one employee and each employee is employed in one and only one department. For employee eid, name, address, dob and contact number is required to be stored. Eid serves as a primary key. Address of employee composed of city, zip code, street number and house number. An employee may have more than one contact numbers. An employee may be a manager or an engineer or a developer. For manager role is required to be stored. For engineer engineering type is required to be stored and for developer domain expertise is required to be stored. An employee belongs to exactly one group. No other type of employee can be incorporated in the system. A department has one or many vehicles. Attributes of vehicle includes id, model, make, vehicle type i.e. (Ac or non-Ac). Vehicles are categorized into two…arrow_forward
- A database used in an order-entry system is to contain information about customers, items, and orders. The following information is to be included. – For each customer: Customer number (unique) Valid “ship to” addresses (several per customer) Balance Credit limit Discount – For each order: Heading information: customer number, “ship-to” address, date of order. Detail lines (several per order), each giving item number, quantity ordered – For each item: Item number (unique) Warehouses Quantity on hand at each warehouse Item description For internal processing reasons, a “quantity outstanding” value is associated with each detail line of each order. [This value is initially set equal to the quantity of the item ordered and is progressively reduced to zero as partial shipments are made.] Design a database for this data. note : You were asked to convert the given ERD into relations and implement it into mysql workbench.arrow_forwardAccess 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, ISBNarrow_forwardDentist Mobile System Create use case and sequence diagram and a set of detail use case descriptions for the following dentist mobile system, Whenever new patients are apply the first time, he/she complete a patient information by fill the form that include name, address, phone number and brief medical history, which are stored in the patient information of mobile system. When a patient request to schedule a new appointment or change an existing appointment, the system checks the appointment file for an available time. Once a good time is found for the patient, the appointment is scheduled. usually the mobile system reminder postcard to each patient two days before their appointment.arrow_forward
- An employment agency offers the service of finding the employee candidates for their clients. For this purpose, the agency has to keep track of certain particulars of the candidates such as the name, identification card numbers, address, phone numbers, data of birth, and their field of expertise. They also keep the data of their clients which is the future employer for the candidate's employee. The request for employee is forwarded to the agency by future employer along with the information regarding to the job offered. The information includes the type of jobs, offered salary, type of expertise required and the date when the employee is needed. Therefore, as a database designer, you are required to propose a database design prior to its implementation by presenting the following: (a) Identify ALL possible entities that could exist in the organization process (give suitable entity name), complete all the entities with suitable attributes together with assigned primary key. Use your own…arrow_forwardDRAW AN ER DIAGRAM FOR THE GIVEN SITUATION The video rental company has several branches throughout the USA. The data held on each branch is the branch address made up of street, city, state, and zip code, and the telephone number. Each branch is given a branch number, which is unique throughout the company. Each branch has allocated staff which includes a Manager. The manager is responsible for the day to day running of the given branch. The data held on a member of staff is his or her name, position, and salary. Each member of staff is given a staff number, which is unique throughout the company.Each branch has a stock of videos. The data held on a video is the catalog number, video number, title, category, daily rental, cost status, and the names of the main actors, and the director. The catalog number uniquely identifies each video. However, in most cases, there are several copies of each video at a branch, and the individual copies are identified using the video number. A video…arrow_forwardALO (Anderson - left - overs.) Enterprises is an organization that provides a wide variety of service offerings for clients. Service types available include bookkeeping, computer installation, computer repair, software installation, taxes, advertising, market surveys, etc. Each service engagement may involve multiple types of service and may include multiple employees. Each type of service has a standard hourly billing rate and can not be entered into the database unless at least one of ALQ's employees is capable of performing that type of service. Employees are trained to perform multiple types of services and can work on multiple service engagements. Employees earn a contracted annual salary based on their credentials, regardless of what services they actually end up performing. Clients are required to pay for a given service engagement in full ( with just one check) within two weeks of the completion date. It is possible for a client to pay for more than one service engagement with…arrow_forward
- Question 6 Your company (a manufacturing firm) is undertaking a software systems development. The system is to support an order management tool to help the company better manage its inventory, purchases and receivables. The system should provide automated notifications when payments from customers have not been received within two weeks of the deadline date and should alert the Finance department when payments by the company to suppliers are within one week of its deadline. The system should also provide a unique id for each item of inventory irrespective of its type. Formal mathematical methods will be used in the development of the system. In the following, choose all statements which are true regarding the application of software quality techniques to the system development. a. Tests should include cases where more than unique id is used for the same item of inventory. b. Inspections will provide a static means of validating the user requirements. C. The formal method can be used to…arrow_forwardA university wants to set up a database to record details about its staff, the departments they belong to and the training they attended. The purpose of developing the database is keep the staff information such as staff identity number, staff name, staff address, staff telephone number, staff job title and staff salary. As for the staff telephone number, the database allows keeping more than one of the staff telephone numbers. For the department information, the database keeps the name of the department and its location. It is required that every staff belongs to at least one department. Also, it is required that each department has exactly one staff to lead the department. To improve staff self-development, the university encourages every staff to attend courses. Hence, the database keeps the course information such as the course name, course duration, and course cost. Each staff is required to attend at least one course. For one course, the university can approve a number of staff…arrow_forwardBusiness System ERD Create an ERD based on the Crow’s Foot model, using the following requirements: An INVOICE is written by a SALESREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative. The INVOICE is written for a single CUSTOMER. However, each customer can have many invoices. An INVOICE can include many detail lines (INVOICE_ITEM), each of which describes one product bought by the customer. The product information is stored in a PRODUCT entity. The product’s vendor information is found in a VENDOR entity. You do NOT need to put any fields/attributes into this ERD. Just draw the entities as empty boxes with relationships between them.arrow_forward