Shared by 
Unlock all 8 pages
Get it free by sharing your own notes, buy just this one, or become a member and unlock documents with your plan.
How to unlock this document
Choose the way that suits you. Each one gives you all 8 pages to read online and the PDF to download.
Share your notes, unlock for free
2 free unlocks for every 5 approved uploads
- Upload your own lecture notes, assignments, essays or past papers
- PDF, Word, PowerPoint and Excel files all work, and you can send many at once
- We check each upload; you get a notification when it is approved
- Spend a free unlock on this document or any other, and keep it for good
- Shared under your public username, never your email
Then upload your notes from your profile.
Buy this document
$8 one-time payment
- All 8 pages of this document, yours to keep
- Download the PDF and read it any time, also offline
- No subscription and nothing to cancel
- Find it again any time under My Profile → Library
You log in or create a free account first, then pay securely.
Become a member
Unlock documents from the whole library, which keeps growing
- Choose any documents you like, up to your plan’s unlocks
- Documents you unlock stay yours, even if you cancel later
- Your unlocks start again with every renewal
- Secure checkout by Dodo Payments
You log in or create a free account first, then pay securely.
Compare the plansAlready a member, or bought this before? Log in to open it
About this document
- Pages
- 8 pages
- Price
- $8 one-time, yours to keep
- Membership
- Included in every plan
- Format
- Subject
- Computer Science, Information Systems
- Module
- Milestone 4
This case study covers data modeling, including entity definition matrices, context data models, key-based data models, and fully attributed data models. It helps students understand the process of identifying entities and their attributes for database design. It is for Milestone 4.
What's inside
- Entity/Definition Matrix for major and optional entities
- Context Data Model based on identified entities
- Key-Based Data Model with primary and foreign keys
- Fully Attributed Data Model in third normal form
- Discussion on database normalization and interpretation of user requirements
Who it is for: Students taking a Systems Analysis & Design Methods course. (Undergraduate)
Share with classmates: WhatsApp Telegram X LinkedIn Facebook
Summary
Data modeling is part of systems analysis and design. Students learn how to identify entities and their attributes from forms and interviews.
Entity Definition Matrix
Entities are identified from forms and interviews. Students see how to list major and optional entities with their definitions.
Context Data Model
This model shows relationships between entities. Students learn how to determine cardinalities from interviews or forms.
Key-Based Data Model
Primary keys are added to the context data model. Students see how to choose keys that uniquely identify entities.
Fully Attributed Data Model
Non-key attributes are added to the key-based data model. Students learn how to place attributes in entities.
Key terms
- Entity
- A thing or object in the real world that is distinguishable from other objects.
- Attribute
- A property or detail of an entity.
- Cardinality
- The numerical attributes of the relationship between entities.
- Primary key
- An attribute that uniquely identifies an entity.
- Foreign key
- An attribute in one entity that is a primary key in another entity.
- Normalization
- The process of organizing data to reduce redundancy.
Questions this document helps with
- What are the main entities in this case study?
- How do you determine the cardinality of entities?
- What makes a good primary key?
Summary written with AI from the document's text.
Ask the AI Teacher
Ask any question about this document or your course, and get a clear explanation.
Log in to ask Create a free account
Free accounts can ask 5 questions a day.