You have been hired by a small dental practice to design and implement their database. Two dentists own the practice and want to use MySQL. They have received good references regarding MySQL.
Added by Victoria R.
Step 1
g., patient information, appointment schedules, treatment records, billing information). - Identify any specific reporting or data retrieval needs they may have. Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 80 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
Requirements Specification (this is a fictional scenario) A fitness company stores the current assignments of trainers to customers in a document file like this: Trainer: Jones, William; phone (175) 2219988; hired in: 2019; Customer: Garcia, Robert; phone (175) 7518822; year of birth: 1988; Goal: building endurance; A trainer is always assigned to one customer. We do not keep trainers without customers. After it is registered, a customer may be assigned to one or more trainers. The customer may decide to change the trainer, but previous assignments are not kept. A trainer has at most 1 customer. There is no middle name stored with the trainers or customers. Both must have a phone number. For some trainers, the most recent hiring year is stored. For some clients, the year of birth is stored. All customers must have a goal specified. The first and last name have at most 24 characters each. The phone number will be stored with the following pattern: (ppp) ppppppp. The hiring year and year of birth are numbers with 4 digits. One may want to search based on the first name or last name, phone, goal, hiring year, and year of birth. Task 1 - ERD Model Based on the specification received, create an ERD in MySQL Workbench. Sign the ERD by writing your name in a text object. Take a picture of your ERD. Include in the report file the following: A heading: Task 1 - ERD Model The signed screenshot(s) (image) of the ERD Task 2 - Create database Start writing the SQL script in MySQL Workbench to perform the following operations: Include a comment: Task 2 Create database by... (your name) If there is a database with the provided name, delete that database. Add a database with that name. Mark the created database as the default database for the following operations. Show all the databases, find the created one in the list. Execute and debug the script in MySQL Workbench until it runs without error and performs the above operations.
Akash M.
Suzi's family started their own yoga school and enlarged their house to accommodate four studios. Suzi has recruited you to be their database designer. The database will store information on their members, yoga classes/sessions, and the various yoga exercises: - People must be 16 years of age or older in order to become a member, and they are welcome to assign themselves to more than one class/session per week. - If a class is cancelled, Suzi must be able to contact members via telephone. Members who provide their email address will also be notified via email. - Fixed yoga sessions are scheduled: for example, every Monday morning at 07:00 studio #1 is used, and every Tuesday at 18:00 studio #4 is used. Each class/session record must contain sufficient information to indicate which weekday, time, and studio is reserved for it. - Suzi references each exercise from a particular book, and she would like to keep track of the book IDs and titles in case she needs to do more research on a particular exercise. - Suzi needs to keep track of the different exercises performed at the sessions. She specifically wants to know the name, description, and the length of each exercise in minutes. - Suzi also needs to specify how many times an exercise must be performed per session/class.
Scenario People are always looking for a good recommendation for help with household jobs and chores, such as handyman work, cleaning, and moving. You recognize the business potential of linking prospective clients with workers who perform these household jobs and chores. You decided to name the company Household Help (HHH). Your company will solicit workers who want to perform household chores such as cleaning, shopping and delivery, handyman work, and moving. To record the information to run HHH, first clients need to submit personal information such as their full name, address, phone number, email address, and credit card information for ease of billing. Workers also need to register after their background checks by providing their full name, home address, and email address. You envision that HHH will offer four different types of service that clients can request: cleaning, shopping and delivery, handyman jobs, and moving. Each service will be assigned a unique code so you don't have to repeatedly enter the exact name of the task when you populate the database with appointments. In addition, each service will have a specific pay rate per hour. For example, a handyman's services will be more expensive per hour than those of worker who makes shopping trips and deliveries. To begin, each worker in the database will be associated with one task he chooses to perform. In the future, you can see that workers might want to perform more than one task, so you will design your database to allow that possibility. When the clients call or eventually use the app to schedule a task, they will need to specify the workers they want, the date they need the task performed, and the start and end times.
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