30 Jun case study
Question Description
Case Study – week 6 – (18%):
You were just hired to create a database to track student club and honor society membership at a university.
The following key points have been agreed:
1 Each StudentID will be unique
2 Each Assoc-ID will be unique
3 Each student may belong to zero, one, or many associations, and each association may have zero, one, or many student members.
4 No fields beyond those in the spreadsheet are needed (including additional fields will result in point deductions)
Your objective is to replace the following report with a relational database. Your submission will consist of a word compatible document, and an Access DB.
Here is the un-normalized table notation for the above report:
StudentAssoc (StudentID, LastName, FirstName, Major, (Assoc-ID, Assoc-Name, AssocContact#, AssocStr#))
The specific tasks are listed below, the percentage in parenthesis corresponds to the grade weight for each task: Organize your document to match the tasks below, label each section to match the task.
Name your document Last Name_CaseStudy (i.e. Smith_CaseStudy). When you are asked to provide an explanation or description, you must include sufficient content to demonstrate that you understand the definition, term, concept, etc. and how it applies to this exercise.
SUGGESTION: Review the Terms and Concepts Forum, especially the Many-to-Many and One-To-Many examples. There is also a normalization MP4 file that can be downloaded and viewed in the Resources section.
You must use the following outline in your submission – include the section labels.
1) Review the existing spreadsheet, and the sample data and document any assumptions or constraints you feel are appropriate (beyond those in the key points). (10%)
2) Submit “one” complete functional dependency analysis (all fields must be included at least once), use the functional notation shown on pages 410-413 Examples 14.2, 14.3, 14.4 and 14.5 to document the functional dependencies. Do not submit functional dependencies for each normal form – only one set of functional dependencies is needed. There may be one or more rows of functional dependencies.
Functional notation example: Field A -> Field B, Field C, means that Field A is a determinant for Field B and Field C.
Similarly if a field is dependent on the combination of values of two fields then:
Field X, Field Y -> Field Z
Define functional dependency, and explain one row of the submitted functional dependencies in plain English (use field names and values in this exercise). (20%)
3) Explain the relationship between the entities in plain English – consider one-to-many or many-to-many. (10%)
4)
a) Submit a complete set of 1NF table(s), you must use the table notation shown on page 111 of the Connolly text, include the normal form definition and plain English explanation of why the table(s) is (are) in 1NF – base the explanation on the definitions in the Connolly text (or the Terms and Concepts forum) (10%)
b) Submit a complete set of 2NF table(s), you must use the table notation shown on page 111 of the Connolly text, include the normal form definition and plain English explanation of why the table(s) is (are) in 2NF – base the explanation on the definitions in the Connolly text (or the Terms and Concepts forum) (10%)
c) Submit a complete set of 3NF table(s), you must use the table notation shown on page 111 of the Connolly text, include the normal form definition and plain English explanation of why the table(s) is (are) in 3NF – base the explanation on the definitions in the Connolly text (or the Terms and Concepts forum) (10%)
5) Create an MS Access database, including the data provided, use only the 3NF tables submitted above. Name your database Last Name_CaseStudy (i.e. Smith_CaseStudy). Upload the database to the assignment area as one of the deliverables (5%).
6) Create a Query (In MS Access) that may include one or more tables, as needed, that provides the results for the following request: List each Student_ID, FirstName, LastName, Assoc-ID, Assoc-Name for all students. (5%)
7) Create one Form: New Student Input – this form should include all relevant fields needed (In MS Access) (5%)
8) Create One Report: Association List – list all Associations – this report should include all relevant fields (In MS Access) (5%)
9) Submission content organization, clarity, spelling and grammar (10%)
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 WriteDemy. 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.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. 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.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.