Create a relational database design for the following data model For the image

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

Create a relational database design for the following data model

For the image 
SUPPLIES
PK SupplyID
Projectio
Name
Description
Price
Amount
CUSTOMER
CONSULTING PROJECT
SEMINAR
PK CusromerlD
PK ProjectiD
PK SeminariD
LastName
CustomeriD
SeminarDate
FirstName
Description
SeminarTime
EmalAddress
Location
EncryptedPassword
SeminarTitle
Phone
StreetAddress
City
State
DIALY PROJECT HOURS
CONTACT
ZIP
PK ProjectID
CustomeriD
PK ContactNumber
Spent_hours
Description
ContactiD
Day of_week
ContactType
PRODUCT
INVOICE
LINE_IITEM
PK ProductNumber
PK InvoiceNumber
InvoiceNumber
PK LineNumber
ProductType
InvoiceDate
ProductDescription
PaymentType
Quantity
UnitPrice
SubTotal
UnitPrice
Quantity OnHand
Shipping
Total
Tax.
Total
Transcribed Image Text:SUPPLIES PK SupplyID Projectio Name Description Price Amount CUSTOMER CONSULTING PROJECT SEMINAR PK CusromerlD PK ProjectiD PK SeminariD LastName CustomeriD SeminarDate FirstName Description SeminarTime EmalAddress Location EncryptedPassword SeminarTitle Phone StreetAddress City State DIALY PROJECT HOURS CONTACT ZIP PK ProjectID CustomeriD PK ContactNumber Spent_hours Description ContactiD Day of_week ContactType PRODUCT INVOICE LINE_IITEM PK ProductNumber PK InvoiceNumber InvoiceNumber PK LineNumber ProductType InvoiceDate ProductDescription PaymentType Quantity UnitPrice SubTotal UnitPrice Quantity OnHand Shipping Total Tax. Total
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY