Figure 4-33 shows an EER diagram for a simplified credit card environment. There are two types of card accounts: debit cards and credit cards. Credit card accounts accumulate charges with merchants. Each charge is identified by the date and time of the charge as well as the primary keys of merchant and credit card. a. Develop a relational schema. Figure 4-33: Customer ID Cust Name Cust Address CUSTOMER CARD ACCOUNT Account ID Exp Date Card Type "D" DEBIT CARD Bank No Holds Card Type= "C" CREDIT CARD Cur Bal HH MERCHANT Merch ID Merch Addr CHARGES Charge Date Charge Time Amount
Figure 4-33 shows an EER diagram for a simplified credit card environment. There are two types of card accounts: debit cards and credit cards. Credit card accounts accumulate charges with merchants. Each charge is identified by the date and time of the charge as well as the primary keys of merchant and credit card. a. Develop a relational schema. Figure 4-33: Customer ID Cust Name Cust Address CUSTOMER CARD ACCOUNT Account ID Exp Date Card Type "D" DEBIT CARD Bank No Holds Card Type= "C" CREDIT CARD Cur Bal HH MERCHANT Merch ID Merch Addr CHARGES Charge Date Charge Time Amount
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...
Related questions
Question
100%
Transcribed Image Text:2. Page 193, Problems and Exercises #4-33a. (No need to answer questions b & c.)
Figure 4-33 shows an EER diagram for a simplified credit card environment. There are two types of
card accounts: debit cards and credit cards. Credit card accounts accumulate charges with merchants.
Each charge is identified by the date and time of the charge as well as the primary keys of merchant
and credit card.
a. Develop a relational schema.
Figure 4-33:
o 11 part a.pptx
Customer ID
Cust Name
Cust Address
CUSTOMER
CARD ACCOUNT
Account ID
Exp Date
Card Type
"D"
DEBIT CARD
Bank No
Holds
^
Card Type=
"C"
CREDIT CARD
Cur Bal
HH
MacBook Air
e
D Chp 11 part b.pptx
MERCHANT
Merch ID
Merch Addr
CHARGES
Charge Date
Charge Time
Amount
^|
^
Chp 13 includin....pptx
A
Expert Solution
Step 1Introduction
Relational schema ia a blueprint use dfor describing the database .by the help of relational schema we can get the actual understanding of the database relation like how the data are related by the entities.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
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
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY