I need help with this question.
Given the following database notation:
tblPasswords(Employee First Name, Employee Last Name, Employee Password, Employee Department, Installed Software)
Break the above flat table into the following related tables:
tblEmployee(empNumber*, DeptNumber, ...) – A listing of all employees at Acme Inc
tblPassword(PasswordID*, empNumber, ...) – Contains the network password for each employee
tblDepartment(DeptNumber*, ...) – A list of the departments at Acme Inc
tblInstalledSoftware(ItemTrackingNumbe... empNumber, ...) - The software an employee has on their computer
Document the database design by completing the database notation for each of the tables in the new database and describe the relationships between the tables.
Use Microsoft Access to implement your design.
Create the required tables and necessary fields.
Create the required relationships between tables. Use the menu item Tools-> Relationships to create your relationships.
Add three employees to the employee table and assign each employee a password and department. Adding records to a relational database is difficult without using a program that allows you to easily match the keys between tables. Access provides this capability in the 'Forms' tab. Use Access' help feature to research how to create a form based on more than one table. Also, check into how 'combo boxes' can be used in forms to enter key values into a table.
Assign each employee at least three software programs.
Create two queries using Access' query design window.
The first query should list the employee’s name, their department, and password
The second query should list the employee’s name and the software installed on their computer.