Question: Need help with this activity Introduction to Database Creating Database and Tables Activity 1 Directions: Create the following tables; transaction_table, saleman_table and product_table Consider the

Need help with this activity

Need help with this activity Introduction toNeed help with this activity Introduction to

Introduction to Database Creating Database and Tables Activity 1 Directions: Create the following tables; transaction_table, saleman_table and product_table Consider the fieldnames and data types given for each table. Be able to link the saleman_table and product_table to transaction_table. Create a drop-down menu for Status and Transaction_details Create at least 10 data/record entries in the Transaction_Table. Transaction_table Field names Transaction_Number Customer_Fname Customer_Lname Customer_Address Data types AutoNumber Short text Short text Long text Trans_date date/time Trans_details selections: place order/ payment/on-hold Should be tag to current date Drop down menu only, not a table As indicated in the Product_table Drop down menu only, not a table As indicated in the Salesman_table Product selections: table/chair/desk/cabinet/sofa Status selections: Done/On-Process/Pending Salesman selections: Annie/Benjie/Choy/Dennis Salesman_table Field names Emp name Emp_ID Data types short text short text Data Entries Emp_name Annie Benjie Choy Dennie Emp_ID Emp101 Emp 102 Emp 103 Emp 104 Product_table Data types short text Field names Prod ID Prod_Name Prod_price short text Number Data Entries Prod_ID Prod_Name 10001 Table 10002 Chair 10003 Desk Prod_price 5000 2000 3000 10004 Cabinet 4000 10005 Sofa 8000 Activity 2 Directions: Create a simple database for Library transactions. Be able to add drop-down menus. Create and link tables as necessary. Be able to provide at least 20 data entries

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!