Assignment 1 2023
docx
keyboard_arrow_up
School
Mohawk College *
*We aren’t endorsed by this school
Course
399
Subject
Information Systems
Date
Feb 20, 2024
Type
docx
Pages
3
Uploaded by MateSummer15720
THIS IS AN INDIVIDUAL ASSIGNMENT. COMPLETE INDIVIDUALLY. Database Management and Design Assignment #1
Problem One Consider the three reports in the figure above. The data are samples of data that would appear in the reports like these. a)
Make a list of as many potential entities as the reports suggest. Consolidate any entities that are
synonyms (mean the same thing).
b)
Write out your assumptions based on the data and reports presented. c)
Construct an ERD using Crow’s Foot technique showing the relationships and cardinalities among your entities. Be sure to indicate all primary and foreign keys. Problem Two The Mohawk College After-School program is seeking to improve their student information. They’ve captured information to date in the following table but have found that the data becomes corrupted due to different team members accessing it at the same time. They have asked how they might better capture this information. ParticipantID FirstName LastName High School HS Major AgeGroup Dietary Considerations 1 James Doe Downtown Secondary Science A Halal, Gluten Free 2 Sally Deer Midtown Secondary Art History C No Dairy, Gluten Free, Nut Allergy 3 Fred Buck Uptown Secondary Science B No Green Foods, Vegan 4 Sue Faun Uptown Secondary Music A Gluten Free a)
Restate the tables in First, Second, and Third Normal Form b)
Create an Entity Relationship Diagram from your Third Normal form. Please use Crows Foot. Problem Three
Your database for the After School program has captured the eye of the Mohawk College Video Game club. They have asked you to design a database application for their on-campus Game rental kiosk. They want to track customers, rentals, and items. They also want to start a Loyalty program, whereby they will offer a 20 percent discount on every 10
th
customer rental. a)
Create a data model for the Game Rental business. b)
Create a data dictionary to name each entity, indicate all attributes and identifiers, and describe their types. c)
Name each relationship, describe its type, and specify minimum and maximum cardinalities. d)
Create the relations based on the ERD model used. Problem Four Upload your LinkedIn Learning Certificate from the MS Access Course.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help