Arab Academy for Science, Technology and Maritime Transport
College of Engineering and Technology
Industrial and Management Engineering Department Course: IM433 – Industrial Database Systems Management

Student Name: | Department: | Student Number: |
Sheet #1
Given the following file structure, answer problems 1 through 6.

1. How many records does the file contain, and how many fields are there per record? 2. What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file structure? 3. If you wanted to produce a listing of the file contents by last name, are code, city, state, or zip code, how would you later the file structure? 4. What data redundancies do you detect and how could these redundancies lead to anomalies? 5. Using two relational database tables, PROJECT and MANAGER, eliminate the redundancies discovered in problem 4. Make sure you use the naming conventions and connect the two tables through an appropriate link. 6. Create the relational schema to show how the two database tables in problem 5 are linked.

Given the following file structure answer problem 7 through 13.

7. Identify and discuss the serious data redundancy problems exhibited by this file structure. 8. How many different data sources are likely to be used by the file you examined in problem 7? 9. Based on your findings in problem 7 and 8, how would a relational database environment help eliminate the data redundancy problems? 10. Given your answer to problem 9, how many tables would you use to substantially eliminate the data redundancy problems? What table structures would you recommend? 11. Given your answers to problem 10, show the table contents for each table. 12. Identify the types of relationships (1:1, 1:M, or M:N) between the tables you designed in