summer 2017 name group 2 id number date 23 july 2017 business technology it111 unit 5154690


Summer 2017 Name: Group: 2 ID Number: Date: 23 July, 2017 Business Technology-IT111 Unit Assessment-Portfolio Task Il- Databases 1. Create a database file under your Nome and ID - Perttollo !1. You will create two database tables in there; the first one- below - is called Employee (2 marks IDN NameHoursBorn Kuwait Citizen Add New Field Sara Shoug Afrah 4 Manar 16 1/3/198 9 3/10/1se 27 12/31/1979 33 /18/1981 38 6/7/3982 5 Aisha (New) a. Create the first table (careful with the numbers format!).(5 marks-1.0 for each field) b. Define the primary key. (1 marks) c. Enter the data into the Employees table. (5 marks-1.0 for each record) 2. The second table is called: Wages (1 mark) Wages ID Name Wage Sara 2 Shouq Afrah 4 Manar 5 Aisha $7.50 $8.00 $10.50 $11.50 $11.00 a. Create the second table (careful with the numbers format!).(3 marks-1.0 for each field) b. Define the primary key. (1 marks) c. Enter the data into the Wages table. (5 marks-1.0 for each record)
media%2Fe22%2Fe22053bc-55b6-4bca-8754-27 Summer 2017 Name: Group: 2 ID Number: Date: 23 July, 2017 Business Technology-IT111 Unit Assessment-Portfolio Task Il- Databases 1. Create a database file under your Nome and ID – Perttollo !1. You will create two database tables in there; the first one- below – is called Employee (2 marks IDN NameHoursBorn Kuwait Citizen Add New Field Sara Shoug Afrah 4 Manar 16 1/3/198 9 3/10/1se 27 12/31/1979 33 /18/1981 38 6/7/3982 5 Aisha (New) a. Create the first table (careful with the numbers format!).(5 marks-1.0 for each field) b. Define the primary key. (1 marks) c. Enter the data into the Employees table. (5 marks-1.0 for each record) 2. The second table is called: Wages (1 mark) Wages ID Name Wage Sara 2 Shouq Afrah 4 Manar 5 Aisha $7.50 $8.00 $10.50 $11.50 $11.00 a. Create the second table (careful with the numbers format!).(3 marks-1.0 for each field) b. Define the primary key. (1 marks) c. Enter the data into the Wages table. (5 marks-1.0 for each record)

"Get 15% discount on your first 3 orders with us"
Use the following coupon
FIRST15

Order Now