Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
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)
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...
See similar textbooks
icon
Related questions
Question

SQL FOR THERES TABLES 

Branch Table FK Description Each Branch will have a Unique number Where the branch is located Which city is the branch located in Column Name BR_ID Data Type Size NULL PK NUMBER NO YES BR_ADDRESS BR CITY VARCHAR2 | 100 VARCHAR2 30 NO NO Medicine Table Column Name MED ID Data Type Size NULL PK FK Description Each Medicine will have a Unique number Medicine Name What category the medicine is in The medicine's price What factory has manufactured the medicine (Each Manufacture will have a Unique number) The expiry date for the medicine NUMBER NO YES NO MED NAME |MED TYPE MED PRICE MANU_ID VARCHAR2 30 VARCHAR2 30 FLOAT NO NO NO 30 VARCHAR2 150 NO YES EXP DATE DATE NO Staff Table Column Name S ID S FNAME S_LNAME S ADDRESS BR_ID Data Type NUMBER VARCHAR2 VARCHAR2 Size NULL PK YES FK Description Each Staff will have a Unique number First name of the Staff Last name of the Staff NO NO 30 30 NO Where The Staff is located Each Branch will have a Unique number & which branch the staff works in VARCHAR2 100 NUMBER NO YES Manufacture Table Column Name MANU ID MANU NAME MANU ADDRESS Payment Table Data Type NUMBER VARCHAR2 VARCHAR2 Size FK |Deзcriptiоn NULL NO NO PK Each Manufacture will have Unique number The manufactre's official name Where the main factory is located YES 150 30 Column Name TRANSACTION ID ORDER_ID Data Type NUMBER Size NULL NO PK FK YES Description Each transaction will have Unique number To which order this payment receipt is connected to Which payment method has been used The billed bank's name VARCHAR2 70 NO YES PAY METH BANK DISCOUNTS 50 VARCHAR2 FLOAT VARCHAR2 NO NO NO 50 The discounted amount if there is any
Transcribed Image Text:Branch Table FK Description Each Branch will have a Unique number Where the branch is located Which city is the branch located in Column Name BR_ID Data Type Size NULL PK NUMBER NO YES BR_ADDRESS BR CITY VARCHAR2 | 100 VARCHAR2 30 NO NO Medicine Table Column Name MED ID Data Type Size NULL PK FK Description Each Medicine will have a Unique number Medicine Name What category the medicine is in The medicine's price What factory has manufactured the medicine (Each Manufacture will have a Unique number) The expiry date for the medicine NUMBER NO YES NO MED NAME |MED TYPE MED PRICE MANU_ID VARCHAR2 30 VARCHAR2 30 FLOAT NO NO NO 30 VARCHAR2 150 NO YES EXP DATE DATE NO Staff Table Column Name S ID S FNAME S_LNAME S ADDRESS BR_ID Data Type NUMBER VARCHAR2 VARCHAR2 Size NULL PK YES FK Description Each Staff will have a Unique number First name of the Staff Last name of the Staff NO NO 30 30 NO Where The Staff is located Each Branch will have a Unique number & which branch the staff works in VARCHAR2 100 NUMBER NO YES Manufacture Table Column Name MANU ID MANU NAME MANU ADDRESS Payment Table Data Type NUMBER VARCHAR2 VARCHAR2 Size FK |Deзcriptiоn NULL NO NO PK Each Manufacture will have Unique number The manufactre's official name Where the main factory is located YES 150 30 Column Name TRANSACTION ID ORDER_ID Data Type NUMBER Size NULL NO PK FK YES Description Each transaction will have Unique number To which order this payment receipt is connected to Which payment method has been used The billed bank's name VARCHAR2 70 NO YES PAY METH BANK DISCOUNTS 50 VARCHAR2 FLOAT VARCHAR2 NO NO NO 50 The discounted amount if there is any
Order Table Column Name Data Type Size NULL PK FK Description Each order will have Unique number The order's name Where the main factory is located ORDER ID NUMBER NO YES ORDER NAME VARCHAR2 70 ORDER DATE DATE 20 CUSTOMER ID NUMBER NO YES To whom this order is connected to (each customer will have a Unique number) YES Which medicine (each medicine will have a Unique number) MED ID NUMBER NO Customer Table Data Type FK Description Each Customer will have a Column Name Size NULL PK CUSTOMER_ID NUMBER NO YES Unique number First name of the customer CUSTOMER FNAΜΕ VARCHAR2 | 20 NO last name of the customer Date of birth of the customer The customer's habitant CUSTOMER LNAME VARCHAR2 20 CUSTOMER DOB DATE NO CUSTOMER ADDRESS VARCHAR2 225 Inventory Table Data Type Description Which slot is occupied What medicine is stored Column Name Size NULL PK FK INV ID NUMBER NO YES MED ID NUMBER NO ITEM_QUANT NUMBER 250 NO How much of the medicine is stored To check whether the item is ЕMPTY BOOLEAN NO available or not
Transcribed Image Text:Order Table Column Name Data Type Size NULL PK FK Description Each order will have Unique number The order's name Where the main factory is located ORDER ID NUMBER NO YES ORDER NAME VARCHAR2 70 ORDER DATE DATE 20 CUSTOMER ID NUMBER NO YES To whom this order is connected to (each customer will have a Unique number) YES Which medicine (each medicine will have a Unique number) MED ID NUMBER NO Customer Table Data Type FK Description Each Customer will have a Column Name Size NULL PK CUSTOMER_ID NUMBER NO YES Unique number First name of the customer CUSTOMER FNAΜΕ VARCHAR2 | 20 NO last name of the customer Date of birth of the customer The customer's habitant CUSTOMER LNAME VARCHAR2 20 CUSTOMER DOB DATE NO CUSTOMER ADDRESS VARCHAR2 225 Inventory Table Data Type Description Which slot is occupied What medicine is stored Column Name Size NULL PK FK INV ID NUMBER NO YES MED ID NUMBER NO ITEM_QUANT NUMBER 250 NO How much of the medicine is stored To check whether the item is ЕMPTY BOOLEAN NO available or not
Expert Solution
steps

Step by step

Solved in 4 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
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
SEE MORE TEXTBOOKS