Database Creation – With Microsoft Access
maladam
Faculty.accdb| 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 |
