Course : Database system EntityA many-to-many relationship is split into a pair of one-to-manyrelationships, connecting with a linked entity.Primary Key (PK)Sales PersonProduct_PartPartSupplierinte ger(10)varchar(255) NI Address varchar(255) NIDProductiD inte ger(10)inte ger(10)E Name varchar(100) NIDIDinte ger(10)E Namea NameE Address varchar(255) NPartIDinte ger(10)varchar(255) NOne-to-Many RelationshipCustomerSupplier PartSupplierlD inte ger(10)EmployeeProductinte ger(10)Sales_PersonlD in teger(10)varchar(255) Nvarchar(255) NIDOrderinte ger(10)varchar(255) NE Address varchar(255) NIDE-- 04IDinteger(10)IDinteger(10)CustomeriD integer(10)H Titlevarchar(255) NH NamePartIDinte ger(10)NameE AddressOrderLineAssemblingProductiDEmployeelD integer(10)Foreign Key (FK)ProductiD in te ger(10)integer(10)OrderiDinte ger(10)ColumnA Qtyinteger(10) NCreate all tables that are mentioned on above ERD.Add five record on each table.Apply all functions on each table.

Following are the tables for mysql for above ERD.

Entity relationships, connecting with a linked entity. Primary Key (PK) Sales Person Product Part ProductiD inte ger(10) inte ger(10) Part Supplier integer(10) varchar(255) N A Address varchar(255) N ID ID inte ger(10) ID inte ger(10) Name PartiD Name varchar(100) N Name varchar(255 E Address varchar(255- One-to-Many Relationship Customer Employee Supplier Part inte ger(10) Sales_PersonlD integer(10) varchar(255) N varchar(255) N ID Order Product inte ger(10) varchar(255) N H Address varchar(255) N ID SupplierID inte ger(10) inte ger(10) A CustomeriD integer(10) inte ger(10) H Title varchar(255) N F- - O ID ID A Name PardD inte ger(10) E Name H Address OrderLine Assembling Foreign Key (FK) – - ProductiD inte ger(10) ProductiD integer(10) OrderiD integer(10) EmployeelD integer(10) Column A Qty integer(10) N Create all tables that are mentioned on above ERD. Add five record on each table. Apply all functions on each table.

Entity relationships, connecting with a linked entity. Primary Key (PK) Sales Person Product Part ProductiD inte ger(10) inte ger(10) Part Supplier integer(10) varchar(255) N A Address varchar(255) N ID ID inte ger(10) ID inte ger(10) Name PartiD Name varchar(100) N Name varchar(255 E Address varchar(255- One-to-Many Relationship Customer Employee Supplier Part inte ger(10) Sales_PersonlD integer(10) varchar(255) N varchar(255) N ID Order Product inte ger(10) varchar(255) N H Address varchar(255) N ID SupplierID inte ger(10) inte ger(10) A CustomeriD integer(10) inte ger(10) H Title varchar(255) N F- - O ID ID A Name PardD inte ger(10) E Name H Address OrderLine Assembling Foreign Key (FK) – - ProductiD inte ger(10) ProductiD integer(10) OrderiD integer(10) EmployeelD integer(10) Column A Qty integer(10) N Create all tables that are mentioned on above ERD. Add five record on each table. Apply all functions on each table.

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

Explain the concept of distributed databases and their advantages over centralized databases.
Short answer What are the most significant advantages of using a database-driven approach? Computer database
When have you encountered databases being used?
Which disadvantages are associated with using a database?
What's the database's core?
Which disadvantages are associated with using a database?
Use as many examples as possible. This question suggests bottom-up or top-down parsers are stronger:
In database administration, what are the three most important jobs to perform?
A company database involves six steps.
Explain the concept of distributed databases and how they differ from centralized databases.
What are the benefits of using mobile databases?
Explain how object-oriented design and relational database design are similar and different.