Develop an entity-relationship model for the following scenario. A piano manufacturer wants to keep track of all the pianos it makes individually. Each piano has an identifying serial number and a manufacturing completion date. The manufacturer has piano technicians who are responsible for inspecting the instruments before they are shipped to the customers. Each piano is inspected by one or more technicians (identified by their employee number). For each separate inspection, the company needs to record its date and a quality evaluation grade.

Develop an entity-relationship model for the following scenario. A piano manufacturer wants to keep track of all the pianos it makes individually. Each piano has an identifying serial number and a manufacturing completion date. The manufacturer has piano technicians who are responsible for inspecting the instruments before they are shipped to the customers. Each piano is inspected by one or more technicians (identified by their employee number). For each separate inspection, the company needs to record its date and a quality evaluation grade.

Principles of Information Systems (MindTap Course List)

12th Edition

ISBN:9781285867168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter12: Systems Development: Investigation, Analysis, And Design

Section: Chapter Questions

Problem 12SAT: Data modeling is most often accomplished through the use of a(n) __________________. a....

See similar textbooks

Similar questions

Draw an E-R diagram for the description below. Ebony and Ivory, a piano manufacturer, wants to keep track of all the pianos it makes. Each piano has an identifying serial number and a manufacturing completion date. Each instrument represents exactly one piano model. Each piano model has an identification number and a name. Over time, the company often manufactures thousands of pianos of a certain model, and the model design is specified before any single piano exists. Ebony and Ivory employs piano technicians who are responsible for inspecting the instruments before they are shipped to the customers. Each piano is inspected by at least one technician (identified by their employee number). Each technician has a set one or more specialties. Some technicians may not be responsible for inspection jobs. For each separate inspection, the company needs to record its date and a quality evaluation grade. The piano technicians have a hierarchy of reporting relationships: some of them have…
Draw an E-R diagram for the description below. Ebony and Ivory, a piano manufacturer, wants to keep track of all the pianos it makes. Each piano has an identifying serial number and a manufacturing completion date. Each instrument represents exactly one piano model. Each piano model has an identification number and a name. Over time, the company often manufactures thousands of pianos of a certain model, and the model design is specified before any single piano exists. Ebony and Ivory employs piano technicians who are responsible for inspecting the instruments before they are shipped to the customers. Each piano is inspected by at least one technician (identified by their employee number). Each technician has a set one or more specialties. Some technicians may not be responsible for inspection jobs. For each separate inspection, the company needs to record its date and a quality evaluation grade. The piano technicians have a hierarchy of reporting relationships: some of them have…
A company makes items. Each item has a name, ID and component quantity. Every item contains many components. Each component can be supplied by one or more suppliers. Suppliers have names and IDS. Each component has ID, name, description, suppliers who supply them, and items in which they are used. Not all suppliers provide components, and a component is not always associated with a supplier. Also, a component always have to be associated with one or more items. Finally, the company contact customers using their IDs, Names and Phones to sell them items. A customer can buy one or more items.
Create a Crow's Foot ERD for the following description: The KwikTite Corporation operates many factories. Each factory is located in a region, and each region can be "home" to many of KwikTite's factories. Each factory has many employees, but each employee is employed by only one factory.
Read carefully the following case:Imagine that you work as an internal auditor for a company that owns several pharmacies throughout the city. Based on your audit plan, the first cycle to audit will be revenue. The first thing you do is document the processes related to receiving and processing the various sources of income. On your initial visit, you were able to observe the following:Once customers have the items to purchase, they head to the register, where a clerk processes the sale. The pharmacy has three cash registers, but does not have an employee who specifically works as a cashier at each one. This provides flexibility in the operation because, of the three employees that the business has, one can collect at any of the cashiers when available. By not having to leave a single person as a cashier, the cashier can focus on providing more direct customer service, refilling merchandise on the shelves, and even assisting in receiving or dispatching merchandise from the store.At the…
Create an Entity Relationship Diagram using the following scenario: A restaurant chain has several store locations in a city (with a name and postal code stored for each), and each is managed by one manager. Managers manage only one store. Each restaurant location has its own unique set of menus. Most have more than one menu (e.g., lunch and dinner menus). Each menu has many menu items, and items can appear on multiple menus, and with different prices on different menus.
Transfer the following description into an ER Diagram: A company has one or more locations referred to as "Plants" (Plant-ID). Several plants are uniquely assigned to the same company code (CC-ID). Plants can have several storage locations (S-loc-#) in which the manufactured and purchased items are stocked, a storage location however, can only be assigned to one plant. A purchase organisation (PO-ID) can be assigned to several plants and a plant to several purchase organisations. A company code is related to one or more purchase organisations, the latter is uniquely related to a company code. A distribution channel (DC-#) can be assigned to several divisions (Div-ID), whereas a division is uniquely assigned to a distribution channel. A sales organisation (Sales-Org-ID) can have several distribution channels, whereas a distribution channel is uniquely assigned to a sales organisation. A company code can have several sales organizations. Sales organisations are assigned to one…
Draw the EER diagrams for the following problems using UML notation, Crow’s Foot notation and Chen notation: A large organization has several parking lots, which are used by staff. Each parking lot has a unique name, location, capacity, and number of floors. Each parking lot has parking spaces, which are uniquely identified using a space number. Members of staff can request the use of a parking space. Each member of staff has a unique number, name, telephone extension number, and vehicle registration number. The majority parking spaces are under cover and can be allocated for use by a member of staff for a monthly rate. Parking spaces that are not under cover are free to use when available. Up to twenty covered parking spaces are available for use by visitors to the company. However, only members of staff are able to book out a space for the day of the visit. There is no charge for this type of booking, but the member of staff must provide the visitor’s vehicle license number.…
Draw an ERD for the following problem:Company organized into departments. Each department has unique, name and a particular employee who manages the department. Start date for the manager is recorded. Department may have several locations. A department controls a number of projects. Projects have a unique name, number and a single location. Company’s employees name, ssno, address, salary, sex and birth date are recorded. An employee is assigned to one department, but may work for several projects (not necessarily controlled by her dept). Number of hours/week an employee works on each project is recorded; the immediate Supervisor for the employee. Employee’s dependents are tracked for health insurance purposes (dependent name, birthdate, relationship to employee).
Draw the ER/EER model for the given scenario. Manufacturer have unique name, an address, and a phone number. Products have a product_id, a name and price. Products may be classified into electronics and grocery. Electronic products have description, type attributes. Groceries have fssai_number, date_of manufacture, date_of_expiry. Each product is made by one manufacturer, and different manufacturers may produce different products.. Customers are identified by their unique social security number. They have email addresses, and physical addresses. Several customers may live at the same (physical) address, but we assume that no two customers have the same email address. An order has a unique order number, and a date. An order is placed by one customer. For each order, there are one or more products ordered, and there is a quantity for each product on the order
Draw clearly from existing scenario text the Entity Relationship Diagram (ERD) “There is a group of employees who have run the website. Three admins are responsible to check registration forms filled by babysitters. An accountant is responsible to check fees payments. All these employees are supervised by the manager. Each babysitter can register on the website one time by filling in her data including first and last names, qualifications, fee rate per hour (25 SAR per Hour), contact information, address, photo, and years of experience. The system will issue for her id and registration date. Mothers can make booking as many as they need. For each time, they must fill in their names, contact information, address, number of children, the date and time (e.g. from 2:00 PM to 4:PM) of booking. The website will generate the booking report including mother’s data, babysitter’s contact data, number of booked hours, fee rate per hour, fees total amount, and tax (%5). To make a…
Develop an activity diagram based on the following narrative. Note any ambiguities or questions that you have as you develop the model. If you need to make assumptions, also note them. The shipping department receives all shipments on outstanding purchase orders. When the clerk in the shipping department receives a shipment, he or she finds the outstanding purchase order for those items. The clerk then sends multiple copies of the shipment packing slip. One copy goes to purchasing, and the department updates its records to indicate that the purchase order has been fulfilled. Another copy goes to accounting so that a payment can be made. A third copy goes to the requesting in- house customer so that he or she can receive the shipment. Once payment is made, the accounting department sends a notification to purchasing. Once the customer receives and accepts the goods, he or she sends notification to purchasing. When purchasing receives these other verifications, it closes the purchase…