You were just hired to create a database to track student club and honor society membership at a university.

Get Help from Experts

If you’re still asking yourself, “Who can help me write my paper from scratch", don’t hesitate to use us. Experienced writers will immediately write, proofread, or improve your academic paper. They can also help you choose a topic and edit your references into APA or MLA format. So, what are you waiting for?

Find your writer

Question Description

 

 

Case Study – week 6 – (18%):

Get Help from Experts

If you’re still asking yourself, “Who can help me write my paper from scratch", don’t hesitate to use us. Experienced writers will immediately write, proofread, or improve your academic paper. They can also help you choose a topic and edit your references into APA or MLA format. So, what are you waiting for?

Find your writer

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%)

Paper Due? Why Suffer? That's Our Job!

Order New Solution