Discuss how to identify and interpret business rules and incorporate the business rules into a data model.
Added by Jes-S A.
Step 1
- Collect documentation such as business process maps, existing data models, and any relevant policies or regulations. Show more…
Show all steps
Your feedback will help us improve your experience
Madhur L and 101 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
What three (often conflicting) database requirements must be addressed in database design? Discuss.
Madhur L.
Akash M.
The system development team at the Wilcon Company is working on developing a new customer order entry system. In the process of designing the new system, the team has identified the following data entity attributes: Inventory Order Order Number (identifier) Order Date Customer Name Street Address City State Zip Customer Type Initials District Number Region Number 1 to 22 occurrences of: Item Name Quantity Ordered Item Unit Quantity Shipped Item Out Quantity Received a. State the rule that is applied to place an entity in first normal form. Describe how the data would change when in first normal form. b. State the rule that is applied to place an entity into second normal form. Describe how the data would change when in second normal form. c. State the rule that is applied to place an entity into third normal form. Describe how the data would change when in third normal form. d. What other guidelines and rules can you follow to validate that your data model is in good form?
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD