Database Creation – With Microsoft Access

Database Creation – With Microsoft Access

DepartmentID DepartmentName School Description
1 IOTM COBI Contains the majors: SCM and IS
2 MIB COBI Contains the majors: Marketing, Professional Sales, and International Business
3 Accounting COBI Contains the major, Accounting
FacultyID FLastName FFirstName PhoneNumber Salary Office HireDate DeptID
1 Mouse Mickey (419) 555-1234 ¤ 12,000.00 ST 4035 8/1/05 1
2 Duck Donald (419) 555-1233 ¤ 10,000.00 ST 3033 1/1/08 2
3 Disney Walt (419) 555-1222 ¤ 25,000.00 ST 4003 1/1/96 1
4 Smith John (419) 555-1211 ¤ 13,000.00 ST 2033 2/15/01 3

Comments are closed.