Consider the scenario where the ABC company has suppliers supply parts and the two ER diagrams for the scenario: B. Supplier ABN {PK} name address phone It is true that Supplier ABN {PK} name address phone 0..* 0..* -Supply- OC. According to ER Diagram B, the FD below is valid: ABN, part-number --> quantity Supply quantity 0..* 0..* Part part-number {PK} type quantity OA. According to ER Diagram A, a supplier can only provide a fixed quantity of parts for each "supply". B. According to ER Diagram B, a supplier may not supply any parts. OD. According to ER diagram A, the FD below is valid: part-number, type -> quantity Part part-number {PK} type

Consider the scenario where the ABC company has suppliers supply parts and the two ER diagrams for the scenario: B. Supplier ABN {PK} name address phone It is true that Supplier ABN {PK} name address phone 0..* 0..* -Supply- OC. According to ER Diagram B, the FD below is valid: ABN, part-number --> quantity Supply quantity 0..* 0..* Part part-number {PK} type quantity OA. According to ER Diagram A, a supplier can only provide a fixed quantity of parts for each "supply". B. According to ER Diagram B, a supplier may not supply any parts. OD. According to ER diagram A, the FD below is valid: part-number, type -> quantity Part part-number {PK} type

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

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.
UML Activity Diagram for plotting the unemployment rate include swimlanes.
Consider the following scenario and draw an E-R diagram for Cathay airlines. Cathay Airlines stores details about an airline’s fleet, flights, and seat bookings. The airline has one or more airplanes and an airplane has a model number, a unique registration number, and the capacity to take one or more passengers. An airplane flight has a unique flight number, a departure airport, a destination airport, a departure date and time, and an arrival date and time. Each flight is carried out by a single airplane. A passenger has given names, a surname, address and a unique email address. . Each address is made up of a street, a city and a postcode. A passenger can book a seat on a flight.
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.
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Eastern Sales Company keeps information on employees and the departments that they work in. For each department, the department name, internal mail box number, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried employees, hourly employees, or contract employees. All employees are assigned an employee number. This is kept along with the employee’s name and address. For hourly employees, hourly wage and target weekly work hours are stored (e.g. the company may target 40 hours/week for some, 32 hours/week for others, and 20 hours/week for others). Some salaried employees are salespeople that can earn a commission in addition to their base salary. For all salaried employees, the yearly salary amount is recorded in the system. For salespeople, their…
Question 3 Draw a complete ER diagram using Crow's foot notation based on the given business rules below: A sales representative can write many invoices. (In a business environment, each invoice represents a sales transaction. Given the "commission set" label, one might infer that the sales rep earns a commission on each sale for which an invoice is written) Each invoice is written by a single sales representative. A customer can generate many invoices. (Each time a customer makes a purchase of one or more items, and invoice is generated) Each invoice is generated by a single customer. Each invoice includes one or more invoice lines. (Each item purchased is recorded in an invoice line) Each invoice line is associated with one (and only one) invoice. Each invoice line records a single product. Each product can be recorded in many invoice lines. (If the inventory contains 100 hammers, each one may be sold and, therefore, each of those 100 hammers may at some point be recorded in an…
Draw Entity Relationship Diagram (ERD) and Class Diagram for the following scenarios: Shaza Holding Sdn Bhd. has many workshops in Klang Valley. This company asks you to develop an ER model following below specifications: Most of the cars are sent to several workshops by customer for repair. A car is uniquely identified by Register no, Model, Year_Produce, Insurance_ID, and Insurance_Policy_No and customer has IC_No, Name, Address, Tel_No and License_No. A car is sent to a workshop depending on the types of breakdown. Date_repair and date_after_repair should be recorded. Each workshop has Workshop_No, Workshop_Name, Tel_No, Address and Manager_Name. Each workshop sells products where each product is uniquely identified by Product_no, Product_Name, Selling_Price and Purchase_Price. The supplier information is Supplier_No, Supplier_Name, Address, Manager_Name and Supplier_Telno. One customer can send more than one car to workshop for repair. A customer also can buy more than one product…
Consider the scenario described by the statement “A customer can make many payments,but each payment is made by only one customer.” Use this scenario as the basis for anentity relationship diagram (ERD) representation using either Chen, Crow’s Foot or UMLClass Diagram.
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy, if appropriate. Granite Sales Company keeps information on employees and the departments in which they work. For each department, the department name, internal mailbox number, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried, hourly, or work on contract. All employees are assigned an employee number, which is kept along with the employee’s name and address. For hourly employees, hourly wages and target weekly work hours are stored; for example, the company may target 40 hours/week for some employees, 32 for others, and 20 for others. Some salaried employees are salespeople who can earn a commission in addition to their base salary. For all salaried employees, the yearly salary amount is recorded in the system. For salespeople, their commission percentage on sales and…
Given the following business scenario, create a Crow's Foot ERD using a specialization hierarchy if appropriate. Granite Sales Company keeps information on employees and the departments in which they work. For each department, the department name, internal mailbox number, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried, hourly, or work on contract. All employees are assigned an employee number, which is kept along with the employee's name and address. For hourly employees, hourly wages and target weekly work hours are stored; for example, the company may target 40 hours/week for some employees, 32 for others, and 20 for others. Some salaried employees are salespeople who can earn a commission in addition to their base salary. For all salaried employees, the yearly salary amount is recorded in the system. For salespeople, their commission percentage on sales and commission…
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Granite Sales Company keeps information on employees and the departments in which they work. For each department, the department name, internal mailbox number, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried, hourly, or work on contract. All employees are assigned an employee number, which is kept along with the employee’s name and address. For hourly employees, hourly wages and target weekly work hours are stored; for example, the company may target 40 hours/week for some employees, 32 for others, and 20 for others. Some salaried employees are salespeople who can earn a commission in addition to their base salary. For all salaried employees, the yearly salary amount is recorded in the system. For salespeople, their commission percentage on sales and commission…
Construct an E-R diagram for a local car-insurance company in Salalah, whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents.