a relational database design

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

CUSTOMER
CONSULTING PROJECT
SEMINAR
PK CusromerlD
PK ProjectID
PK SeminarID
CustomeriD
LastName
SeminarDate
FirstName
Description
SeminarTime
EmailAddress
Location
EncryptedPassword
SeminarTitle
Phone
StreetAddress
City
DIALY PROJECT HOURS
State
%23
CONTACT
PK ProjectID
ZIP
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
QuantityOnHand
Shipping
Total
Tax
Total
Transcribed Image Text:CUSTOMER CONSULTING PROJECT SEMINAR PK CusromerlD PK ProjectID PK SeminarID CustomeriD LastName SeminarDate FirstName Description SeminarTime EmailAddress Location EncryptedPassword SeminarTitle Phone StreetAddress City DIALY PROJECT HOURS State %23 CONTACT PK ProjectID ZIP 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 QuantityOnHand Shipping Total Tax Total
Expert Solution
steps

Step by step

Solved in 2 steps with 2 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