Addis Ababa Institute of Technology
ITSC

Fundamentals of Database Systems

Laboratory Practice

Note: This laboratory practice will be evaluated at the end (10% of final grade)
Prepared BY:

Tigabu D.

Based on the information given below Develop: i) ER diagram for the company ii) Convert the ER diagram you designed in question I in to tables (relational database) iii) Implement the tables and relationships in question ii using a DMBS of below a. Microsoft access 2007/2010/2013 (Select One version) b. My SQL or Windows SQL Server 2005/08/12 (Select One version)

Company Information:

■ The company is organized into Departments. Each department has a name, number and an employee who manages the department. We keep track of the start date of the department manager. A department may have several locations. ■ Each department controls a number of Projects. Each project has a unique name, unique number and is located at a single location. ■ We store each Employee’s social security number, address, salary, sex, and Birthdate. ■ Each employee works for one department but may work on several projects. ■ We keep track of the number of hours per week that an employee currently works on each project. . ■ Each employee may have a number of Dependents. ■ For each dependent, we keep track of their name, sex, Birthdate, and relationship to the employee.

Answers to the questions i) The ER diagram will look like the following

[pic] ii) The tables that will result after reduction of the ER in to table (relational database)

[pic]