Branch Table Column Name BR_ID Data Type NUMBER FK Description Each Branch will have a Unique Size NULL PK NO YES number BR_ADDRESS BR CITY VARCHAR2 100 VARCHAR2| 30 NO NO Where the branch is located Which eity is the branch located in Medicine Table Column Name |MED_ID Data Type NUMBER NULL NO PK FK Description Each Medicine will have a Unique number Medicine Name What caterorY the medicine is in The medicine's price YES What factory has manufactur medicine (Each Manufacture will have a Unique number) The expiry date for the medicine Size YES NO VARCHAR2 MED NAME МED TYPE, MED PRICE MANU_ID NO 30 VARCHAR2 30 NO NO NO FLOAT 30 150 VARCHAR2 Ithe | EXP DATE |DATE NO Staff Table FK YES Column Name S ID S FNAME S LNAME S ADDRESS BR_ID Description Each Staff will have a Unique mumber First name of the Staff Last name of the Staff Where The Staff is located Each Branch will have a Unique number & which branch the staff works in Data Type NUMBER VARCHAR2 NULL PK NO NO NO Size 30 VARCHAR2 30 VARCHAR2 NUMBER 100 NO YES Маnufacture Table Column Name MANU ID MANU NAME MANU ADDRESS Payment Table Data Type NUMBER NULL NO NO FK Description Each Manufacture will have Unique mumber The manufacture's official name Where the main factory is located Size PK YES VARCHAR2 150 |VARCHAR2 30 Column Name TRANSACTION ID NUMBER ORDER_ID Description Each transaction will have Unique number YES To which order this payment receipt is Data Type Size NULL FK PK YES NO NO VARCHAR2 70 |PAY METH BANK DISCOUNTS соmmected to Which payment method has been used The billed bank's name The discounted amount if there is any VARCHAR2 NO NO NO 50 VARCHAR2 FLOAT 50
Branch Table Column Name BR_ID Data Type NUMBER FK Description Each Branch will have a Unique Size NULL PK NO YES number BR_ADDRESS BR CITY VARCHAR2 100 VARCHAR2| 30 NO NO Where the branch is located Which eity is the branch located in Medicine Table Column Name |MED_ID Data Type NUMBER NULL NO PK FK Description Each Medicine will have a Unique number Medicine Name What caterorY the medicine is in The medicine's price YES What factory has manufactur medicine (Each Manufacture will have a Unique number) The expiry date for the medicine Size YES NO VARCHAR2 MED NAME МED TYPE, MED PRICE MANU_ID NO 30 VARCHAR2 30 NO NO NO FLOAT 30 150 VARCHAR2 Ithe | EXP DATE |DATE NO Staff Table FK YES Column Name S ID S FNAME S LNAME S ADDRESS BR_ID Description Each Staff will have a Unique mumber First name of the Staff Last name of the Staff Where The Staff is located Each Branch will have a Unique number & which branch the staff works in Data Type NUMBER VARCHAR2 NULL PK NO NO NO Size 30 VARCHAR2 30 VARCHAR2 NUMBER 100 NO YES Маnufacture Table Column Name MANU ID MANU NAME MANU ADDRESS Payment Table Data Type NUMBER NULL NO NO FK Description Each Manufacture will have Unique mumber The manufacture's official name Where the main factory is located Size PK YES VARCHAR2 150 |VARCHAR2 30 Column Name TRANSACTION ID NUMBER ORDER_ID Description Each transaction will have Unique number YES To which order this payment receipt is Data Type Size NULL FK PK YES NO NO VARCHAR2 70 |PAY METH BANK DISCOUNTS соmmected to Which payment method has been used The billed bank's name The discounted amount if there is any VARCHAR2 NO NO NO 50 VARCHAR2 FLOAT 50
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
SQL FOR THERES TABLES
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 3 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