Week 2 - Data Model Assignment Logical Data Modeling - Jaya Krishna Gurram
docx
keyboard_arrow_up
School
Wilmington University *
*We aren’t endorsed by this school
Course
7000
Subject
Industrial Engineering
Date
Feb 20, 2024
Type
docx
Pages
6
Uploaded by AgentFire14999
Data Model Assignment: Supertypes/Subtypes
Week 3 – Data Model Assignment: Supertypes/Subtypes
Jaya Krishna Gurram
IST 7000: Data Management
Professor: Mr. Bert Gibbons
Wilmington University
November 12, 2023
Data Model Assignment: Supertypes/Subtypes
Data Model Assignment: Supertypes/Subtypes
All the Entities:
Events
Recording_Devices
Asset_Creators
Assets
Format_Types
Publishing_Devices
Attributes in Each Entity:
Events Entity:
1.
event_id
2.
event_name
3.
event_description
4.
start_date
5.
end_date
Recording_Devices Entity:
1.
recording_device_id
2.
Format_type_code
3.
device_name
4.
device_description
5.
supplier
Asset_Creators Entity:
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
Data Model Assignment: Supertypes/Subtypes
1.
creator_id
2.
first_name
3.
middle_name
4.
last_name
Assets Entity:
1.
asset_id
2.
creator_id
3.
event_id
4.
format_type_code
5.
date_of_creation
6.
asset_title
7.
location
8.
description
9.
playing_time
Format_Types Entity:
1.
format_type_code
2.
Format_type_description
Publishing_Devices Entity:
1.
device_id
2.
format_type_code
3.
device_name
4.
device_ description
5.
supplier
Primary Key for Each Entity:
1.
creator_id
2.
event_id
Data Model Assignment: Supertypes/Subtypes
3.
asset_id
4.
recording_device_id
5.
format_type_code
6.
device_id
Foreign Keys:
1.
creator_id
2.
event_id
3.
format_type_code
All the Relationship Cardinalities Between Entities:
1.
Asset_Creators to Assets:
One-to-Many (1:N)
One Asset_Creator can be associated with multiple Assets.
Each Asset is created by one and only one Asset_Creator.
2.
Events to Assets:
One-to-Many (1:N)
One Event can have multiple associated Assets.
Each Asset is linked to one and only one Event.
3.
Assets to Format_Types:
Many-to-One (N:1)
Multiple Assets can be associated with one Format_Type.
Each Asset is associated with only one Format_Type.
Data Model Assignment: Supertypes/Subtypes
4.
Recording_Devices to Format_Types:
Many-to-One (N:1)
Multiple Recording_Devices can use the same Format_Type.
Each Recording_Device is associated with only one Format_Type.
5.
Format_Types to Publishing_Devices:
One-to-Many (1:N)
One Format_Type can be used by multiple Publishing_Devices.
Each Publishing_Device is associated with only one Format_Type.
Relationship Between Entities:
1.
creator_id attribute in Asset_Creators entity is used to match to the creator_id attribute in Assets entity.
2.
event_id attribute in Events entity is used to match to the event_id attribute in Assets entity.
3.
Format_type_code attribute in Assets entity is used to match to the format_type_code attribute in Format_Types entity.
4.
Format_type_code attribute in Recording_devices entity is used to match to format_type_code attribute in Format_Types entity.
5.
Format_type_code attribute in Format_Types entity is used to match to format_type_code
attribute in Publishing_Devices
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