You have just been named Director of Data Administration of General Hardware Co. General Hardware maintains a large central IS organization with several operational relational databases at its headquarters. It also has databases on several local-area network servers, some located at its headquarters and some in regional offices. Of course, there are many relational databases on individual employees PCs, too. Certain data is sent from the central databases to the LAN databases nightly.

You have been given a free hand to create a data administration department and support database administration departments for General Hardware and its IS environment.

Design your data and database administration functions. Include their responsibilities and explain how they will add value to the corporation.

Create a data dictionary TABLES table and an ATTRIBUTES table and enter data in them for General Hardware database.

Create relationships table for this tables and attributes data.

Draw the ER Diagram