Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Fundamentals of Database Systems Lab Assignment 1 Due date: Monday, 21/9/2020 Using Microsoft Access, Answer the following questions and upload your document on Blackboard. 1-

image text in transcribed
Fundamentals of Database Systems Lab Assignment 1 Due date: Monday, 21/9/2020 Using Microsoft Access, Answer the following questions and upload your document on Blackboard. 1- Create a table called home_work with the following specifications Column Data Type value Hw ID Number(3) Hw Name Text(30) Hw_Publish_Date Date date 2. Modify the home_work Table to make the following changes : 1- Add new column , Hw_due_date Date 2- Add new column , Hw_points Number, its field size is (2) 3- Add new column , Hw_Subject data type is Text, field size is (40) 4- Add New column , HW_Status data type is Text, field size is (6) 5- Change the size of Hw_Name to be data type is Text, field size is (50) 6-Change the Size of HW_ID to be Number and its field size is (5) 7- Drop the column HW_Status 3. Rename the Table to be Home_works instead of home_work Fundamentals of Database Systems Lab Assignment 1 Due date: Monday, 21/9/2020 Using Microsoft Access, Answer the following questions and upload your document on Blackboard. 1- Create a table called home_work with the following specifications Column Data Type value Hw ID Number(3) Hw Name Text(30) Hw_Publish_Date Date date 2. Modify the home_work Table to make the following changes : 1- Add new column , Hw_due_date Date 2- Add new column , Hw_points Number, its field size is (2) 3- Add new column , Hw_Subject data type is Text, field size is (40) 4- Add New column , HW_Status data type is Text, field size is (6) 5- Change the size of Hw_Name to be data type is Text, field size is (50) 6-Change the Size of HW_ID to be Number and its field size is (5) 7- Drop the column HW_Status 3. Rename the Table to be Home_works instead of home_work

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Sector Accounting And Auditing In EuropeThe Challenge Of Harmonization

Authors: I. Brusca, E. Caperchione, S. Cohen, F Manes Rossi

3rd Edition

1137461330, 9781137461339

More Books

Students also viewed these Accounting questions

Question

10. Generalize Probs. 8 and 9 to a $k \times k$ matrix.

Answered: 1 week ago

Question

Differentiate between gender equality and gender equity.

Answered: 1 week ago