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

Q2: Draw an E-R diagram Representing the relationship between Employee with Attribute EmpID, Name, Address And Project with Attributes proj-id and proj-Name. Each employee may be assigned one or more projects, or may not be assigned any project on the other hand one or more projects, may be assigned to an employee.
Consider the following scenario Students have to use a range of lab equipment to complete their projects. Each Use involves an instance of STUDENT, PROJECT, and EQUIPMENT. If a student uses two pieces of equipment to work on a project, there are two instances of the relationship uses. A campus lab may use the attribute, the date of use, in this ternary relationship to log the equipment usage. 1. Using any application of your choice, e.g. Microsoft Visio or SmartDraw, create an ER diagram of the ternary relationship between all the entities, relationships and attributes for students using lab equipment for their projects.
Draw an ERD for each of the following situations. (If you believe that you need to make additional assumptions, clearly state them for each situation.) Use MS Visio to draw the models. 2. A laboratory has several chemists who work on one or more projects. Chemists also may use certain chemicals on each project. Attributes of CHEMIST include Employee ID (identifier), Name, and Phone No. Attributes of PROJECT include Project ID (identifier) and Start Date. Attributes of CHEMICAL include Compound No and Cost. The organization wishes to record Volume Used—that is, the amount of a given chemical used by a particular chemist working on a specified project. A chemist must be assigned to at least one project and one chemical on each project to which he or she is assigned. A given chemical need not be assigned to any project, and a given project need not be assigned to either a chemist or a chemical. Provide good definitions for all of the relationships in this situation. Please give proper…
Given the following conceptual representation: Based on the participation of Department and Employee in manages, what can you conclude?c) Based on the cardinality of works, what can you conclude? Explain the corresponding business ruled) Mention one alternate key for Projecte) What is supervises in this diagram? Provide as many details as possible f) Convert the E-R diagram into tables. You can draw tables or provide the Relational Schema g) What do you need to modify to specify that every employee must have a supervisor? Details matter h) How would you include suppliers in this diagram? Provide a clear explanation and illustrate your answer with an extract of your original E-R diagram
Develop a context diagram and a level-0 diagram for the contracting system described in the following narrative. If you discover that the narrative is incomplete, make up reasonable explanations to complete the story. Supply these extra explanations along with the diagrams. Government Solutions Company (GSC) sells computer equipment to federal government agencies. Whenever a federal agency needs to purchase equipment from GSC, it issues a purchase order against a standing contract previously negotiated with the company. GSC holds several standing contracts with various federal agencies. When a purchase order is received by GSC’s contracting officer, the contract number referenced on the purchase order is entered into the contract database. Using information from the database, the contracting officer reviews the terms and conditions of the contract and determines whether the purchase order is valid. The purchase order is valid if the contract has not expired, the type of equipment…
Use ER Assistant to draw your diagram. Draw an ER diagram that includes entities for Clients, Contracts, and Contacts. Clients have the following attributes: ClientID (primary key), ClientName, ClientAddress. Contracts have the following attributes: ContractID (primary key), ContractType, LicenseFee. Contacts have the following attributes: ContactID (primary key), ContactName, ContactAddress. Draw a relationship between Clients and Contracts such that a Client can be assigned to many contracts, but it can also exist without having any contracts at all in the database. Conversely, a contract can be assigned to only one client but must be assigned to a client in order to exist. Name your relationship “Signs”. Draw a relationship between Clients and Contacts such that a client must be assigned to one and only one contact. A contact can exist in the database without being assigned to a client, but a contact can be assigned to more than one client. Name your relationship “Has”.
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.
A Central University wants to automate their all kind of fee payment such as admission, examination, course registration and re-registration and hostel for all type of courses through online, uploading their academic details as document and document verification for confirming their payment for the specific course. Design this application by providing the entity relationship diagram and data flow diagrams for the scenario given above.
It is requested to draw an entity relationship diagram (ERD) for a hospital management system.Information about the subject are given below.• The patients contain ID, name, and surname. Doctors have name, surname, and department.Rooms have number and capacity.• Each doctor may supervise zero or more patients.• Each patient should be supervised by one doctor.• Each room may host zero or more patients.• Each patient should be hosted in one room.
Create an ER/EER diagram for the following 1. Professors have an SSN, a name, an age, a rank, and a research specialty. Projects have a project number, a sponsor name (e.g., NSF), a starting date, anending date, and a budget. Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S.or Ph.D.). Each project is managed by one professor (known as the project’s principalinvestigator). Each project is worked on by one or more professors (known as the project’s co-investigators). Professors can manage and/or work on multiple projects. Each project is worked on by one or more graduate students (known as the project’sresearch assistants). When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a (potentially different) supervisor for each one. Departments have a department number, a department name, and a main office. Departments have a professor (known…
Your Question: Task 7. create a set of representative use cases for the system create a use case diagram showing system boundary, actors, use cases, and relationships. Then, for a subset of important use cases, create the following: Normal scenarios (at least four use cases) Augment two of the use cases to consider alternate flows (abnormal scenarios) Two misuse case scenarios with added content to use case diagram Task 8. create Activity Diagrams for at least one normal and one abnormal scenario Task 9. create Sequence diagrams for at least one normal and one abnormal scenario Task 10. create a Data Flow Diagram for the System Task 11. create a List of Functional Requirements Task 12. create a List of Non-functional Requirements Task 13. create a Traceability Table Show use cases are connected to requirements. All for a hypothetical social media app called Snapster
Can you please create a swim-lane process diagram for a Bakery for the Production Department? DESIGN and DRAW a high-level “as-is” swim-lane process diagram depicting the process above. The diagram should show the bands, process flows, roles, and/or cross-functional interactions required, as well as where two or more decisions are made. Cross-functional interactions can include the following departments: Production Department which bakes the bread; Distribution Department that delivers the bread; Sales Department where customer orders and wholesale pickups are managed; Marketing that promotes and manage the company’s branded products; Finance and Accounting that manages the customer accounts.

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