Explaining the Benefits of A Newly Designed Database
Order ID:89JHGSJE83839 Style:APA/MLA/Harvard/Chicago Pages:5-10 Instructions:
Explaining the Benefits of A Newly Designed Database
Now it’s time to apply your knowledge of normalization and good design practices to revise your own database design.
Prepare a report with the following components:
- Your ER diagram from the previous module
- Translate your ER diagram into relational database design using the notation introduced in pages 88 and 104 of the textbooks. New, foreign keys might be introduced during the translation. Highlight the foreign keys you created.
- Specify the relationships between the tables.
- A paragraph explaining in what normal form your database design is. Explain your reasoning.
- If your design is not in at least third normal form, revise it so it is in at least third normal form. Provide the revised diagram and explain your reasoning for why the diagram is now in at least third normal form. If your design is already in the third normal form or higher, you do not have to revise it but still do explain your reasoning.
- Provide three specific examples of data anomalies that will be avoided due to your third normal form or higher database design. Explain your reasoning.
- Come up with a case based on your database design, with examples, to illustrate 2NF might be a preferred normal form in your design.
3
Database needed: Elementary school database holding parent, student and employee info.
Person interviewed: first last.
After explaining the benefits of a newly designed database that is comprehensive in fulfilling the required elements and secure from outside breaches and is owned in house instead of paid for by a monthly subscription, the school’s administration agrees that a new system would be of benefit to their school.
Details:
- What is the data to be maintained: Student and parent demographics, student grade levels and scores, state test results, discipline records, health and immunization records, tuition records
- Data elements:
- first name, last name, middle name of parents and students
- street number, street name, city, state, zip code of home address
- grade level of each student
- grade of student in each class
- class names [English, Math, Social Studies, Reading, Foreign Language, Art]
- first name, last name, and middle name of teachers and other employees
- tuition rates, fees amounts
- immunizations [MMR, Varicella, DTP, Hep A, Hep B, Meninigitis]
- banking routing numbers and account numbers for ACH payments
- New or existing system? There is a system in place but it is not performing satisfactorily and is missing some desired elements.
- Consequences if data is not maintained properly—If the data is not maintained properly, security breaches could reveal bank account numbers, health information concerning students, marital statuses of the student’s parents and any attached legal judgments, scores of students could be exposed, personal info such as birthdates, addresses and social security numbers of parents and employees
- What is wrong now that new system would fix the current system has the following deficiencies:
- No place to enter state test scores
- No place for social security numbers
- No way to enter immunizations
- No way to scan in incoming records from other schools
- Is this replacement, why is existing system inadequate:
- System is clunky
- System crashes/freezes frequently
- Above items are necessary to have in the database
- Current system ‘loses’ info and it has to be re-entered
- Monthly subscription to database is costly
- Who are stakeholders: School board and administration
- Are there any legal, ethical, or privacy concerns that should be taken into account when creating and implementing the system? Because so much personal and private information is held in the school database, it is vital that it is highly secure to prevent any loss of personal or financial info
- Is this project feasible within the constraints of this class? ie: technology, budget???
Yes
- Validate the plan with the person interviewed and get approval
Approved by first last