Data base assignment
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
7
Uploaded by MateSummer15720
SHRIJAN SHARMA (000881278) Database Management and Design Assignment -1 1_ Problem One
a)
Make a list of as many potential entities as the reports suggest. Consolidate any entities that are synonyms (mean the same thing).
List of potential entities from the
report:
Company
Product
Ingredients
Nutrient
Vitamin-iron
Issuer
Supplier
b)
Write out your assumptions based on the data and reports presented.
The assumptions which I made based on the data and reports are assumptions are
random samples, independence, normality,
equal variance, stability, and that your measurement system is accurate and
precise. In this post, we'll address random samples and statistical independence.
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.
SHRIJAN SHARMA (000881278) Problem Two
a) Restate the tables in First, Second, and Third Normal Form
Participate ID
FirstName
LastName
High School
Major
AgeGroup
DietarConsideration
1
James
Doe
Downtown
Secondary
Science
A
Hala
1
James
Doe
Downtown
Secondary
Science
A
Gluten free
2
Sally
Deer
Midtown
Secondary
Art History
C
No Dairy
2
Sally
Deer
Midtown
Secondary
Art History
C
Gluten Free
2
Sally
Deer
Midtown
Secondary
Art History
C
Nut Allergy
3
Fred
Buck
Uptown
Secondary
Science
B
No Green Food
3
Fred
Buck
Uptown
Secondary
Science
B
Vegan
4
Sue
Faun
Uptown
Secondary
Music
A
Gluten Free
SECOND NORMAL FORM(2NF)
Participate ID
FirstName
LastName
High School
Major
AgeGroup
1
James
Doe
Downtown
Secondary
Science
A
2
Sally
Deer
Midtown
Secondary
Art History
C
3
Fred
Buck
Uptown
Secondary
Science
B
4
Sue
Faun
Uptown
Secondary
Music
A
Participate ID
DietarConsideration
1
Hala
1
Gluten Free
2
No Dairy
2
Gluten Free
2
Nut Allergy
3
No green food
3
Vegan
4
Gluten free
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
THIRD NORMAL FORM (3NF)
Participate ID
FirstName
LastName
AgeGroup
1
James
Doe
A
2
Sally
Deer C
3
Fred
Buck
B
4
Sue
Faun
A
Participate Education
Participate ID
High School
Major
1
Downtown
Secondary
Science
2
Midtown
Secondary
Art History
3
Uptown
Secondary
Science
4
Uptown
Secondary
Music
Participate Diet
Participate ID
DietarConsideration
1
Hala
1
Gluten Free
2
No Dairy
2
Gluten Free
2
Nut Allergy
3
No green food
3
Vegan
4
Gluten free
a)
an Entity Relationship Diagram from your Third Normal form. Please use Crows Foot.
SHRIJAN SHARMA (000881278) Problem 3
Customer
Game
Cust Fname
Cust LName
Game Name
Game Type
Rental
Cust ID
Game ID
Due date
Return of date
Create a data dictionary to name each entity, indicate all attributes and identifiers, and describe their types.
Table
Attribute Field
Data Type
Width
Description
Customer
Cust ID
Number
20
Client Identification Number
Cust FName
Short Text
60
Customer First Name
Cust LName
Short Text
60
Customer Last Name
Game
Game
Number
20
The game has a unique ID.
Game Name
Short Text
60
Game Title
Game Type
Short Text
60
Game Genre
Rental
Rental
Number
20
Identification number for the rental
Due Date
Date
20
Game Rent Due Date
Return of Date
Date
20
Actual Game Return Date
b)
Name each relationship, describe its type, and specify minimum and maximum cardinalities. Sr. No.
Relationship Name
Type
Minimum Cardinality
Maximum Cardinality
1
Customer Rental
Many-to-Many
0
Many
2
Game Rental
Many-to-Many
0
Many
c)
Create the relations based on the ERD model used.
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
SHRIJAN SHARMA (000881278) Problem Four Upload your LinkedIn Learning Certificate from the MS Access Course.