Assume that you have the situation in which:• Suppliers can supply products for projects.• A supplier can supply a particular product for multiple projects.• A product for a particular project can be supplied by multiple suppliers.• A project can have a particular supplier supply multiple products.• A supplier has a key attribute supplier_ID, a project has a key attribute project_ID, and a product hasa key attribute product_IDDraw an ER-diagram that captures the above description. You must also include the quantity and due datefor supplying a particular product to a particular project by a particular supplier.

Answered: Image /qna-images/answer/cec7973f-b961-44e5-8588-c204ed045be1.jpg

Answered: Assume that you have the situation in…

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

Identify the Actors and the Use Cases from the customer requirements in Appendix-A . Briefly describe them and draw the use case diagram using an UML tool . Prepare Detailed Use Case Descriptions with UML Activity Diagrams for “Submit Homework” and one other Use Case you identify from Moodle (Student Information System) software that has actor of type “student”. For all diagramming use Gliffy (https://www.gliffy.com/) or another UML modeling tool you prefer. APPENDIX-A Online Hotel Reservation System RichOS hotels owner Mr. Tompkins wanted an online reservation system (HORSE) for his new hotel located in Antalya. The hotel has two types of rooms: regular and suit. In order to make a reservation or cancel any other, the clients (persons or travel agency) must logon the system. The clients should register to the system through their names, e-mail and telephone information. Clients will be able to query the availability of the rooms selecting a date interval and room type. The client will…
Develop a context diagram and level-0 Data flow diagram for the following case study: Online Flight Reservation systems are a set of applications that support the direct contact between an airline and its passengers. The reservation systems contain airline schedules, fare rates as well as passenger and ticket reservations. The reservation system allows customers to make reservations via the use of internet and mobile phone applications. There are three user levels within the ticket booking system: User, Agent, and Administrator. Users have basic permissions in the ticket booking system, can search the desired destination, choose a seat and make a payment in one click. Agents are users who can manage the functionality and have access to all features within the system. The administrator can manage every aspect of the system, has visibility to all features, and changes system settings. Using the searching functions, you can select a round trip, one way or multi-city, enter the city you…
create an Enhanced Entity-Relationship (EER) diagram based on the provided information. Based on the following description, try creating the diagram using a tool such as draw.io, Lucidchart, or any other ER diagram tool: Entities: Person: person_ID (PK), name, address, birth date, phone number Subtypes: Employee, Physician, Patient, Volunteer Visit: date (PK, partial identifier), comments Care Centre: care_centre_ID (PK), name, location Laboratory: lab_ID (PK), name, location Bed: bed_number (PK), room_number, care_centre_ID (FK) Item: item_number (PK), description, unit_cost Treatment: treatment_ID (PK), treatment_number, treatment_name, treatment_date, treatment_time, results Relationships: Works_In (Person - Care Centre): Person (1, M) ----< Works_In >---- (1, M) Care Centre Assigned_To (Employee - Care Centre): Employee (1, M) ----< Assigned_To >---- (1, M) Care Centre Assigned_To (Physician - Care Centre): Physician (1, M)…
Draw ER diagram for the following upload the diagram ?? A laboratory has several chemists who work on one or more projects. Chemists also may use certain kinds of equip- ment on each project. Attributes of CHEMIST include Em- ployee_ID (identifier), Name, and Phone_No. Attributes of PROJECT include Project ID (identifier) and Start_Date. Attributes of EQUIPMENT include Serial_No and Cost. The organization wishes to record Assign_Date-that is, the date when a given equipment item was assigned to a particular chemist working on a specified project. A. chemist must be assigned to at least one project and one equipment item. A given equipment item need not be as- signed, and a given project need not be assigned either a chemist or an equipment item. Provide good definitions for all of the relationships in this situation.
1) Add a couple of attributes (including Primary keys) to each entity set. 2) Use Reification to transform it into a diagram with only binary relationships.
Create a Crow's Foot ERD Model for a Train Station with these entities. I already did the ERD Diagram! What are the Cardnitalities in the Diagram and give me an explanation for the Relationship? Entities: Train Station Schedule Passengers Route Stop
Question 2 Draw an activity Diagram in draw.io and screenshot it for me. Scenario Each subject has 1 lecture class and 4 tutorial classes. Each lecture class can have a maximum of 80 students only and each tutorial class can have a maximum of 20 students only. From the system, the faculty will generate a list of subjects that have registered students. Then the list of academicians for the faculty is displayed. For each academician, the faculty can assign either 1 lecture class or 3 tutorial classes. The faculty will keep assigning duty to the academicians until there are no more lecture or tutorial classes.
Quiz-2 Section C 1. What is the purpose of activity diagram? Give a situation where you should use the forking concept. [4] 2. Draw an activity diagram for the following case [16] A swimline diagram for the following scenario to withdraw money from an ATM. Use only this description (do not make up your own information!). The customer inserts the ATM card and then enters their pin number. The Bank system then validates the pin. If the pin is invalid, the ATM machine ejects the card, the customer takes the card, and the scenario ends. Assuming the card pin was valid, the customer enters an amount to withdraw. The bank checks the account balance. If the balance is less than the amount to withdraw, the ATM shows the balance, and then ejects the card. Once ejected the customer then takes the card and the scenario ends. Assuming the amount is available, the customer takes money from the slot and at THE SAME TIME the bank debits the account. Once the customer has taken money and the account…
Create a UML Activity Diagram for processing an order. Once an order has been finalized, four parties are involved in processing it: Online Sales, Accounting, Shipping, and Printing. Online Sales receive the order and sends the order to Printing, where the associated PDF file is inspected. If the file is not suitable, a new file is requested from the customer, and the received new file goes for the inspection. Once the file is suitable, Accounting is informed to charge the credit card. While this is done, Printing carries out the actual printing, and sends the result to Shipping. When Shipping has both received the printed products and confirmation from Accounting that payment was successful, the products are shipped to the customer. answer step by step and take screen shoot for your answer
Draw an Entity Relationship Diagram for the proposed system based on therequirements showing the Entities, Attributes and Cardinality between entities. Entities and Attributes Flavor Attributes: FlavorID, Name, Description Inventory Attributes: InventoryID, FlavorID, Quantity, ReorderThreshold Sale Attributes: SaleID, CustomerID, FlavorID, Date, Quantity, TotalAmount Customer Attributes: CustomerID, Name, Email, Phone Feedback Attributes: FeedbackID, CustomerID, Comment, Date, Rating Supplier Attributes: SupplierID, Name, ContactInfo Order Attributes: OrderID, SupplierID, FlavorID, OrderDate, Quantity, DeliveryDate Forecast Attributes: ForecastID, FlavorID, PredictedDemand, Date Relationships and Cardinality Flavor - Inventory One Flavor can have multiple inventory records. (1:N) Flavor - Sale One Flavor can be part of multiple sales. (1:N) Customer - Sale One Customer can have multiple sales. (1:N) Customer - Feedback One Customer can…
3. Use case model: a. What does a use case diagram depict? b. Create a use case model for a travel agency. This should include all 3 parts of the use case model.
Q1. Draw an E-R Diagram for the following situation. At the university system each STUDENT must be assigned an ADVISOR who counsels students about degree requirements and helps students register for classes (COURSE). Each student must register (REGISTRATION) for classes with the help of an advisor, but if the student's assigned advisor is not available, the students may register with any advisor, We must keep track of students, the assigned advisor for each, and the name of the advisor with whom the students registered for the current term. Tips: Attributes of STUDENT include Student ID (the identifier), Name, and Major. Attributes of ADVISOR include Advisor ID (the identifier), Name, and Department. Attributes of COURSE include Course ID (the identifier), Title, and Credits. Attributes of REGISTRATION include Semester, and Year. Based on your background, think of logical and standard relationships between the given entities.

SEE MORE QUESTIONS

Recommended textbooks for you

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

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

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

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

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

C How to Program (8th Edition)

Computer Science

ISBN:

9780133976892

Author:

Paul J. Deitel, Harvey Deitel

Publisher:

PEARSON

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781337627900

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Programmable Logic Controllers

Computer Science

ISBN:

9780073373843

Author:

Frank D. Petruzella

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS