Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
SQL FOR THERES TABLES

SQL FOR THERES TABLES

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 

Staff Table Column Name Data Type Size NULL PK FK Description Each Staff will have a Unique number S ID S FNAME S LNAME S ADDRESS NUMBER NO YES VARCHAR2 30 NO First name of the Staff Last name of the Staff Where The Staff is located VARCHAR2 30 NO VARCHAR2 | 100 BR ID NUMBER NO YES Each Branch will have a Unique number & which branch the staff works in Manufacture Table Column Name Data Type Size NULL РК FK Description Each Manufacture will have Unique number The manufacture's official name Where the main factory is located MANU ID NUMBER NO YES MANU NAME VARCHAR2 | 150 NO MANU ADDRESS VARCHAR2 30 Payment Table Data Type TRANSACTION ID NUMBER Column Name Size NULL PK FK Description Each transaction will have Unique number To which order this payment receipt is NO YES ORDER ID VARCHAR2 70 NO YES connected to PAY MΕ ΤΗ Which payment method has been used The billed bank's name The discounted amount if there is any VARCHAR2 50 NO BANK VARCHAR2 50 NO DISCOUNTS FLOAT NO
Transcribed Image Text:Staff Table Column Name Data Type Size NULL PK FK Description Each Staff will have a Unique number S ID S FNAME S LNAME S ADDRESS NUMBER NO YES VARCHAR2 30 NO First name of the Staff Last name of the Staff Where The Staff is located VARCHAR2 30 NO VARCHAR2 | 100 BR ID NUMBER NO YES Each Branch will have a Unique number & which branch the staff works in Manufacture Table Column Name Data Type Size NULL РК FK Description Each Manufacture will have Unique number The manufacture's official name Where the main factory is located MANU ID NUMBER NO YES MANU NAME VARCHAR2 | 150 NO MANU ADDRESS VARCHAR2 30 Payment Table Data Type TRANSACTION ID NUMBER Column Name Size NULL PK FK Description Each transaction will have Unique number To which order this payment receipt is NO YES ORDER ID VARCHAR2 70 NO YES connected to PAY MΕ ΤΗ Which payment method has been used The billed bank's name The discounted amount if there is any VARCHAR2 50 NO BANK VARCHAR2 50 NO DISCOUNTS FLOAT NO
Column Name Data Type Size NULL PK FK Description Each Medicine will have a MED_ID NUMBER NO YES NO Unique number Medicine Name MED_NAME VARCHAR2 30 NO What category the medicine is in The medicine's price YES What factory has manufactured the medicine (Each Manufacture will have a Unique number) The expiry date for the medicine MED_TYPE VARCHAR2 | 30 NO MED PRICE FLOAT 30 NO MANU_ID VARCHAR2 150 NO EXP DATE DATE NO Medicine Table
Transcribed Image Text:Column Name Data Type Size NULL PK FK Description Each Medicine will have a MED_ID NUMBER NO YES NO Unique number Medicine Name MED_NAME VARCHAR2 30 NO What category the medicine is in The medicine's price YES What factory has manufactured the medicine (Each Manufacture will have a Unique number) The expiry date for the medicine MED_TYPE VARCHAR2 | 30 NO MED PRICE FLOAT 30 NO MANU_ID VARCHAR2 150 NO EXP DATE DATE NO Medicine Table
Expert Solution
steps

Step by step

Solved in 3 steps

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