Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Creat employee table and key for the inventory database system. Follow the table above. 1. Employee (khalil) Emp_ID FName LName Gender Address Postcode State Phone
Creat employee table and key for the inventory database system. Follow the table above.
1. Employee (khalil) Emp_ID FName LName Gender Address Postcode State Phone Primary key: Emp_ID Data type: field size: Input mask: Caption: P 2 2. Sales (chai) Time Emp_ID E222 E555 Sales_ID Product_ID S100 S101 S102 S103 S104 Primary key: Sales_ID Date 16/11/2020 28/11/2020 7/12/2020 23/12/2020 2/1/2021 Cust_ID C003 C001 C002 C004 C005 10.00 am 2.00 pm 3.10 pm 11.00 am 5.20 pm E333 E111 E444 Data type: field size: Input mask: CaptionStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Database Design Application Development And Administration
Authors: Michael V. Mannino
4th Edition
0615231047, 978-0615231044
