Create a detailed ERD using the Entities and Attributes document provided with the Service Request. Create a Microsoft® Access® database using the ERD created above. You do not need to include keys and relationships at this point. Include the following: • Tables with appropriate data types • Descriptions • Format • Masking Submit the ERD, memo, and Microsoft® Access® database file to your facilitator.
I gave you the wrong memo!
Here is the memo I wrote for this assignment:
To: XXXXX XXXXX Services/Logistics Manager at Taylor Ambulance
RE: Service Request SR-ta-001 Scheduling System Database
This memo is to inform you that a service request SR-ta-001 has been submitted and brought to my attention. This request has been processed and is currently in motion to be completed. The purpose of this memo is to advise you on the development and state of this service request. At this time I am actively normalizing the database to the 3rd normal form. Through normalizing the database to the 3rd level of normalization, I will ensure that the data is properly and accurately arranged in the database. This process includes getting rid of duplicate and unnecessary data that exists within the database relations. Normalizing the data to the usual third will positively affect the customer by aid the provision of room while making data more accessible by removing redundant data saved in several relations. Normalizing to this level will also guarantee scalability, data integrity, as well as storage efficiency. I can state with certainty that you will no longer have repetitive rows or columns in the same tables and in addition, each column maintains one value and one data type. Because of this step in the resolution, the level one normalization has been completed. From this point I have proceeded to normalize the database to the 2nd level of normalization. This level has reached an accomplished state by making sure that each non key attribute is fully dependent on the key columns of the table. At the point when normal form of level 1 and 2 reached completion I moved forward by combining foreign and primary keys creating relationships. I will update you as the project reaches near completion.
Meredith L. Hall
From a managers perspective employees using the new database will receive training through attending extensive workshops, and other offered training dates to ensure that all users have been educated and been given the necessary knowledge one how to properly operate the system and the expected performance from this new system. The accomplished objective with this new product is to reduce redundancy and inaccurate data entry. I look forward to hearing your response and listening to your ideas, and uncovered issues or concerns with the database.
Meredith L Hall