Question: This is a database assignment on Access. Please explain how to enter all of this information in correctly. Create two tables, DEPARTMENT and WORKER in
Create two tables, DEPARTMENT and WORKER in Computer Assignment 1 database file. DEPARTMNENT table contains the following fields: DeptID, DeptName, and NumberOfWorkers. WORKER table contains the following fields: WorkerID, WorkerName, Date Hired, Salary, and DeptID. DeptID is a foreign key. - Define Primary keys for the two table - Enforce referential integrity between them. - Use appropriate data type for the fields. Rules i) DeptId is a Text field, size 3 bytes. First two characters are upper case letters, and third character is a digit. ii) Salary cannot be greater than $100,000. iii) Date Hired must be less than the current date iv) WorkerName cannot be blank
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
