03 Jun Entity Relationship Diagram (ERD) and Normalized Tables Instructions In this phase of the project you will determine the entities needed to support
Phase 2: Entity Relationship Diagram (ERD) and Normalized Tables
Instructions
In this phase of the project you will determine the entities needed to support your project requirements outlined in Phase 1. Your deliverable for this phase will be:
- Entity Relationship Diagram (see Figure A-10 on page AC A-10) depicting entities and their underlying relationship. The final ERD will show entities and display their name, their attributes, primary keys, foreign keys, and relationship between entities.
- Display a list of tables in 3NF similar to the example on page AC A-20. This is a crucial step in your database design and if not done correctly the subsequent phases will not return the desired outcome. Be sure to submit this on time and incorporate recommended changes.
- Copy and paste the class diagram to a Word document that also contains the list of tables in 3NF as described above.
Running head: Database project 1
Database project 3
Database project
Institution:
Student’s name:
Date:
Project Title
Database for medical coverage for households
Project Scope
The project focuses on the medical and health needs of every household within a given region. This entails collecting the personal details of all individuals within the region and linking the collected data to the expected benefits from the covers. Among the details collected in the project include number of family members in the household, the level of income of the household, whether either parents or single parents or guardian responsible of children if there are children. Also, the ages of the family members can be collected within the household. In addition, the livelihood or income generating activity can be investigated in effort to determine the ability of the household to make premiums on time as per the agreement of the insurance contract.
Project Description
The project aims at determining the relationship between the size of the family, the income level and the premiums paid by the households based on the expected benefits. The main purpose of the database project would be to provide sufficient information needed to establish whether the premium paid is viable based on the health coverage benefits received by the household. Also, the project can be used in determining whether the premium paid attracts specific characteristics or features of a given population or not. Among the features include the level of income where a pattern can be established between the predominant level of income among the households and the premium packages offered by the medical coverage provider. Another characteristic that can be used in defining the relationships between the variables include the size of the family and the expected benefits from the packages offered. For instance, a link can be drawn between a premium medical cover package and the size of the family or household. For instance, it would be easier to establish whether households with small children prefer one type of package or prefer a different package.
Possible issues
One of the challenges that may be encountered in this project include difficulty in establishing links between variables and the potential benefit it has on the program. For instance, there may challenge in determining the relevance some of the variables has such as age of the child within a household and the package benefits offered in the medical coverage. Another challenge may be developing multivariate analysis tools within the database as part of enhancing the ability to make sound decisions from the system (Stiady & Bennett, 2018).
Stiady, J. L., & Bennett, B. C. (2018). Developing database and reporting system softwares for quality control testing. In Roller Compacted Concrete Dams (pp. 1057-1066). Routledge.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteEdu. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
Do you need help with this question?
Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.
WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.
With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Chat with us today! We are always waiting to answer all your questions.