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...
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

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