Homework Sourse1 Please describe a brief project summary summary of databas
1. Please describe a brief project summary, summary of database requirement. (P. 33 of textbook). (Example) Wedgewood Pacific Corporation (WPC) WPC has grown into an internationally recognized organization. The company is located in tow buildings. One building houses the Administration, Accounting, Finance, and Human Resources departments, and the second houses the Production, Marketing, and information Systems departments. The company database contains data about company employees, departments, company projects, company assets such as computer equipment, and other aspects of company operations. 2. Design a database model. 3. Create a Database. 4. Create tables. 5. Create Queries. 6. Create Forms and Macro. 7. Create Reports.
Solution
Project Summary Step by Step :
Column Name
Type
Key
Required
Remarks
Employee Name
Auto number
Primary key
Yes
First name
Text(30)
No
yes
Last name
Text(30)
No
yes
Department
Text(40)
NO
yes
Phone
Text(12)
No
yes
Text(100)
No
yes
4. Enter the data for WPC employees in EMPLOYEE table .
Employee number
First name
Last name
Department
phone
[Auto number]
Carry
jonson
Finance
369-544-54667
carry@wpc.com
[Auto number]
Steve
bob
Accounting
354-565-6545
steve@wpc.com
[Auto number]
John
rome
Human Resources
233-456-5656
john@wpc.com
[Auto number]
marrine
sur
production
765-564-4544
marrine@wpc.com
[Auto number]
tom
kop
Administration
454-545-4545
tom@wpc.com
[Auto number]
garyian
tue
Accounting
676-676-5676
garyian@wpc.com
5. Create one data form for the EMPLOYEE table and name it WPC_Employee_Data .Make it properly according you wish so data should show proper.It will enter the data into employee table.
6. Create queries to sort the data and retrieve the data from table .
select * from EMPLOYEE
select * from EMPLOYEEorder by last_name
7. Create report form for retrieve the employee data from EMPLOYEE table and display as user view. Make it by sort last
| Column Name | Type | Key | Required | Remarks |
| Employee Name | Auto number | Primary key | Yes | |
| First name | Text(30) | No | yes | |
| Last name | Text(30) | No | yes | |
| Department | Text(40) | NO | yes | |
| Phone | Text(12) | No | yes | |
| | Text(100) | No | yes |
