Project description
1.Describe the process of database planning and design. (30 points)
Please focus on database planning and design in general and do not limit your discussion to the specifications provided in the narrative. Your description should not exceed 1000 words. Use in-text citation for the sources you have used.
2.Develop an Entity Definition Matrix of an Alumni database system based upon the case outlined in the narrative. (20 points)
Analyze the dialogue and provided Excel spreadsheets to identify the entities which should form a part of the database design. Make assumptions where necessary and state these assumptions explicitly.
3.Identify the cardinality of the relationships and represent it in the ER diagram.
(10 points)
Analyze the dialogue and forms provided to identify the conventions which should form a part of the database design. Make assumptions where necessary and state these assumptions explicitly.
4.Design a Data Model of the Alumni Management System, demonstrating the attributes, relationships, PKs and FKs. (20 points)
5.Optimize this data model to the third normal form (3NF). In this process of data normalization, clearly present the intermediate data models of 1NF and 2NF form along with the final data model in the 3NF form. If some aspects of model are purposefully de- normalized, then present arguments to support your decision.
(20 points)
Analyze the dialogue and forms provided to identify the relationships between the entities which should form a part of the database design. Make where necessary assumptions and state these assumptions explicitly.
———-
Added on 03.05.2016 19:07
please check the attached file. one of the file is the instruction and the other two files are lectures on how to draw a relationship data model. Please check all these attachments to do the assignment. You can use outside reference too. Please draw a good diagram.
Instruction files
bis_1_2015_tutorial_week_4.pdf(80,82 KiB)
final_bis1_assignment_2_2016.doc(106,50 KiB)
bis_1_week_3_2015_database.pdf(1,87 MiB)
Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]