17. Create a basic ERD for the given tables: Table name: CUSTOMER Table name: INVOICE CUST NUM CUST LNAME CUST FNAME CUST BALANCE Jeanne Juan NV NUM CUST NUM INV DATE INV AMOUNT 8000 8001 8002 8003 8004 235.89 23-Mar-08 23-Mar-06 30-Mar-08 1000 12-Apr-08 1000 23-Apr-08 1050.11 840.92 1000 1000 Smith 1001 Ortega 312.82 528.10 194.78 1001 1001 619.44 18. Create a basic ERD given the following MS Access schema MODEL AIRCRAFT MOD CODE MOD MANUFACTURER MOD SEATS MOD RENT CHG AC NUM MOD CODE AC TOTAL TIME

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
Answer and explain numbers 17 and 18.
17.
Create a basic ERD for the given tables:
Table name: CUSTOMER
Table name: INVOICE
NV NUM CUST NUM NV DATE INV AMOUNT
23-Mar-08
23-Mar-08
30-Mar-08
12-Apr-08
23-Apr-08
CUST NUM CUST LNAME CUST FNAME CUST BALANCE
1050.11
840.92
Jeanne
8000
1000
235.89
1000 Smith
1001 Ortega
8001
1001
312.82
Juan
528.10
8002
8003
8004
1001
1000
194.78
1000
619.44
18.
Create a basic ERD given the following MS Access schema
MODEL
AIRCRAFT
AC NUM
MOD CODE
AC TOTAL TIME
MOD CODE
MOD MANUFACTURER
MOD SEATS
MOD RENT CHG
Transcribed Image Text:17. Create a basic ERD for the given tables: Table name: CUSTOMER Table name: INVOICE NV NUM CUST NUM NV DATE INV AMOUNT 23-Mar-08 23-Mar-08 30-Mar-08 12-Apr-08 23-Apr-08 CUST NUM CUST LNAME CUST FNAME CUST BALANCE 1050.11 840.92 Jeanne 8000 1000 235.89 1000 Smith 1001 Ortega 8001 1001 312.82 Juan 528.10 8002 8003 8004 1001 1000 194.78 1000 619.44 18. Create a basic ERD given the following MS Access schema MODEL AIRCRAFT AC NUM MOD CODE AC TOTAL TIME MOD CODE MOD MANUFACTURER MOD SEATS MOD RENT CHG
Expert Solution
steps

Step by step

Solved in 3 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