Draw an entity relationship diagram (ERD) for the following situations: (Ctrl) 3. Jim Smith's dealership sells Fords, Hondas, and Toyotas. The dealership keeps information about each car manufacturer with whom it deals so that employees can get in touch with manufacturers easily. The dealership also keeps information about the models of cars that it carries from each manufacturer. It keeps such information as list price, the price the dealership paid to obtain the model, and the model name and series (e.g., Honda Civic LX). The dealership also keeps information about all sales that it has made. (For instance, employees will record the buyer's name, the car the buyer bought, and the amount the buyer paid for the car.) To allow employees to contact the buyers in the future, contact information is also kept (e.g., address, phone number, e-mail).

Draw an entity relationship diagram (ERD) for the following situations: (Ctrl) 3. Jim Smith's dealership sells Fords, Hondas, and Toyotas. The dealership keeps information about each car manufacturer with whom it deals so that employees can get in touch with manufacturers easily. The dealership also keeps information about the models of cars that it carries from each manufacturer. It keeps such information as list price, the price the dealership paid to obtain the model, and the model name and series (e.g., Honda Civic LX). The dealership also keeps information about all sales that it has made. (For instance, employees will record the buyer's name, the car the buyer bought, and the amount the buyer paid for the car.) To allow employees to contact the buyers in the future, contact information is also kept (e.g., address, phone number, e-mail).

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

Suppose that you are given the following information for the articles publications: • Each article is published in a Journal only. Article may have their own identification number, name, and any other relevant information. Articles cannot be duplicated and will be only accepted in a Journal. Journal will have their identification number, name, any other relevant information. • Authors may publish one or more articles at a time, but each article must be distinctive and published in the appropriate journal. If necessary, the author may be required to present their work at a specific conference. The details of the conference must also be recorded. A reviewer will examine an article before it is published. Each reviewer is only allowed to review two articles from the same journal. Sketch an Enhanced Entity Relationship Diagram (Chen's Model) based on the scenario above. Include all the relevant entities and you are also encouraged to add any other relevant entities to specify the…
In Chapter 3 of Sharma et al. (2010), you will be introduced with a case study: "This case study describes a simple Library Management System. Assume the requirements for the system were written by your client exactly in these terms: The system will manage the author's and loaner's information, and keep track of books loaned. The borrower's information includes name, address, e-mail, and phone. The author's information includes name, address, and e-mail. New books, authors and clients are entered into the system. When a client checks out a book, the system will register the date the book was loaned and calculate the days the book can be loaned. It will also calculate the date the book is due to be returned. If the borrower returns the book late, he must pay a fine based on the number of days overdue." (Sharma, et al., 77). Assume that the traditional file system is currently used in this library and a DBMS is to be developed. Discuss the advantages and challenges for the use of…
The scenario is for a small life insurance agency and their need to keep track of clients, agents, insurers, and quotations. 1) A Client is a customer, potential customer, or contact of the agency. We need to assign each client a number and save their last name, first name, birth date, gender, telephone number, email address, and the agent who brought the client into the agency. If a client is a “walk in” they are assigned to the first available agent. All clients must have one primary agent. 2) An agent is a licensed individual with the state. Each agent has a nationally unique license number, last name, first name, telephone number, and email address. An agent must be the primary agent for at least one client but may not be primary for more than 500 clients. An agent must also be part of at least one quotation and may share in an unlimited number of quotes. 3) The agency represents (does business with) many insurance companies (insurers). We will need to track each insurer with an…
The following uependency diagram indicates that a patient can receive many prescriptions for one or more medicines over time. Based on this diagram, draw an ERD whose tables are in at least second normal form (2NF). MedName PatientID Date RefillsAllowed PatientName Dosage Shelf Life To keep track of equipment in a certain university, the following table of information is kept: item_id item_label room_numberbldg_code bldg_name bldg_manager 22123 HP Printer 22133 HP Monitor 22134 HP Monitor 10120 CCIT 10120 CCIT 10245 CCIT 12230 CMB 12230 CMB College of Computing and IT Ali Mohammed College of Computing and IT Ali Mohammed College of Computing and IT Ali Mohammed College of Business Management Seif Willis College of Business Management Seif Willis 33212 HP Printer 23312 HP Printer 1. Draw a dependency diagram of the information found in the table. You can use draw.io and copy/paste the image into your submitted document. 2. Normalize the table into 2NF and write the relational schema. 3.…
Design the UML class diagram to support the system below and upload a picture of your diagram. Used Class Material Website: You are designing a website where students can resale their used material for a course. A course may have multiple sections. The course material is specific to each section of a class. Not all course may require class materials, but they may require many of them. A student can have many used materials for sale. The class material can be either: · Textbook: which has a price(mandatory), title(mandatory), authors(optional), edition(optional) · Software: which has a price(mandatory), title(mandatory), publisher(optional), and also its operating system (mandatory) · Equipment: which has a price(mandatory), title(mandatory), description(mandatory) All class material can be either available or sold. Do a class diagram with: 1. all the classes , 2. their associations 3. their multiplicity . 4. For each classes, where are the…
Alert dont submit AI generated answer.
Think about what you'd want to see in an entity identifier, then write it down.
Draw an ERD for the following scenario: A department employs many employees, but each employee is employed by one department. Each employee has the following characteristics: emp_Num, emp_FName, empLName, empAdress. Each department has a code and a name. Some employees, known as “rovers,” are not assigned to any department. A division operates many departments, but each department is operated by one division. Each division has a code and a name. An employee may be assigned many projects, and a project may have many employees assigned to it. Each project has a code and a name. An assignment is characterized by a date and number of hours. A project must have at least one employee assigned to it. One of the employees manages each department, and each department is managed by only one employee. One of the employees runs each division, and each division is run by only one employee.
Fact-Finding Summary• A typical center has 300–500 members, with two membership levels: full and limited.Full members have access to all activities. Limited members are restricted to activitiesthey have selected, but they can participate in other activities by paying a usage fee. Allmembers have charge privileges. Charges for merchandise and services are recorded on acharge slip, which is signed by the member.• At the end of each day, cash sales and charges are entered into the BumbleBee accounting software, which runs on a computer workstation at each location. Daily cash receiptsare deposited in a local bank and credited to the corporate Personal Trainer account. TheBumbleBee program produces a daily activity report with a listing of all sales transactions.• At the end of the month, the local manager uses BumbleBee to transmit an accounts receivable summary to the Personal Trainer headquarters in Chicago, where member statements are prepared and mailed. Members mail their payments to…
Based on the provided information below, what would be the entities and the relationship between each one? Thank you!
Label each phrase as either interpretation sharing, projection sharing, or fact sharing. Note: each information sharing type is used once. Diesel is leaking from the ship onto the dock. Answer (circle one): interpretation sharing, projection sharing, fact sharing. There is a fire station near the diesel leak. Those firefighters have been trained to respond to small diesel spills. Answer (circle one): interpretation sharing, projection sharing, fact sharing. If the ship leaks more than 10,000 gallons of diesel, then we will need to send in additional firefighters and specialized equipment trucks through Route B. Answer (circle one): interpretation sharing, projection sharing, fact sharing.
Construct an E-R diagram for the following hospital: In this hospital, we have many patients (characterized by social security number, name, insurance, the admission date, and the date of check out) received by medical doctor. Each medical doctor in the hospital is characterized by: ID number, name, and specialization. For every patient, the medical doctor will perform one or more tests and examinations to diagnose his illness. Each test or examination is characterized by an ID, name, date, time, and result. In your ER-Diagram, you must specify the key for each entity and all relationship cardinalities.