Discuss the steps you might take to design a data model based on business rules for a project modeled after a realistic business or personal project.
Added by Luc-A A.
Step 1
Understand what the business or personal project aims to achieve, such as increasing sales, improving customer satisfaction, or streamlining operations. Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 50 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
1. Database Design Assume that you are the database developer for this task, complete the information-level design for the new database for "Mindful Body Fitness Company" that satisfies the constraints and user view requirements given below. Mindful Body Fitness Company is planning to design a data model to hold information relating to their programs, Trainers, exercise logs and their customers. As a database designer for Mindful Body Fitness, you need to ensure that each Exercise Log has a unique ID number, Date, Exercise category, Time spent, calories burnt. Each customer has a unique Cust_number and their first name, last name, address, program number, program title and payment must be recorded. Every program has a program number (PNum) that uniquely identifies the program. The program title, StartDate, Finish Date, Price must also be recorded. Each trainer has a unique ID number. Their first name, last name, date of birth, address, contactNo, user name (unique user name for each trainer) and password must be recorded. A trainer can work on one or more scheduled programs. Each program can have one or more trainers associated with it. One customer can enrol for only one program at one time. Exercise log keeps track of what customers do and customers can maintain one or more exercise logs. Write down any assumptions you make, if they are not explicitly described here While completing the information-level design you are required to answer questions given below 1(a) - (c) a. Identify and list entities described the given case scenario. (5 Marks) b. Outline at least 2 business rules that describes relationships between entities and write the type of the relationship. Eg (1:1, 1:M or M:N) (5 Marks) c. ER diagram Add attributes to those entities and select suitable primary keys for each entity. Represent the structure of your database visually by using the entity-relationship (ER) diagram. I. If you make any assumptions about data that are not explicitly given in the problem, these must be described. II. You are required to use a software tool to create the ER diagram. You can use draw.io[2], Lucidchart [1], Visio or any other software tool to create the ER diagram. (15 Marks)
Akash M.
What three (often conflicting) database requirements must be addressed in database design? Discuss.
Madhur L.
Tim is very impressed with your progress. Good job! You now need to move from analysis to design. Your first design objective is to create a conceptual data model based on Tim's business model. Your conceptual data model needs to align with the following guidelines: 1. Your conceptual model needs to include all the correct relationships between the entities (i.e., one to many, many to many). 2. You need to include all the correct entities, but you don't need to include the attributes for each entity. 3. Your model needs to use Crow's Foot Notation.
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