Complete the object conceptual data model for the following relational schema.

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
a) Complete the object conceptual data model for the following relational schema.
Branch
BranchID
Location
B001
Shatin
ВО02
Homantin
Order
OrderID
SalesTotal
BranchID
0001
100
BO01
0002
200
BO02
0003
300
BO01
BranchID is the primary key of Branch table.
OrderID is the primary key of Order table. BranchID in Order table is the foreign key
references Branch table.
Now, assume the OIDS are given below:
Branch
BranchID
Location
OID
B001
Shatin
OID1
B002
Homantin
OID2
Order
OrderID
SalesTotal
BranchID
OID
0001
100
ВО01
OID3
0002
200
ВО02
OID4
0003
300
ВО01
OID5
Transcribed Image Text:a) Complete the object conceptual data model for the following relational schema. Branch BranchID Location B001 Shatin ВО02 Homantin Order OrderID SalesTotal BranchID 0001 100 BO01 0002 200 BO02 0003 300 BO01 BranchID is the primary key of Branch table. OrderID is the primary key of Order table. BranchID in Order table is the foreign key references Branch table. Now, assume the OIDS are given below: Branch BranchID Location OID B001 Shatin OID1 B002 Homantin OID2 Order OrderID SalesTotal BranchID OID 0001 100 ВО01 OID3 0002 200 ВО02 OID4 0003 300 ВО01 OID5
a) Complete the object conceptual data model for the following relational schema.
Branch
BranchID
Location
B001
Shatin
ВО02
Homantin
Order
OrderID
SalesTotal
BranchID
0001
100
BO01
0002
200
BO02
0003
300
BO01
BranchID is the primary key of Branch table.
OrderID is the primary key of Order table. BranchID in Order table is the foreign key
references Branch table.
Now, assume the OIDS are given below:
Branch
BranchID
Location
OID
B001
Shatin
OID1
B002
Homantin
OID2
Order
OrderID
SalesTotal
BranchID
OID
0001
100
ВО01
OID3
0002
200
ВО02
OID4
0003
300
ВО01
OID5
Transcribed Image Text:a) Complete the object conceptual data model for the following relational schema. Branch BranchID Location B001 Shatin ВО02 Homantin Order OrderID SalesTotal BranchID 0001 100 BO01 0002 200 BO02 0003 300 BO01 BranchID is the primary key of Branch table. OrderID is the primary key of Order table. BranchID in Order table is the foreign key references Branch table. Now, assume the OIDS are given below: Branch BranchID Location OID B001 Shatin OID1 B002 Homantin OID2 Order OrderID SalesTotal BranchID OID 0001 100 ВО01 OID3 0002 200 ВО02 OID4 0003 300 ВО01 OID5
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