Create correct physical and logical entity relationship diagrams (ERD) through draw.io
1. (50 points) A tutoring company wants to set up their database. They are trying to keep track of the following: student ID, name, grade level, the subject they need tutoring in and their contact and payment information. They also want to keep track of the tutors’ information such as their ID, name, subject matter expertise and times available and rate. They will like to keep track of which student is assigned to which tutor and their meeting schedule as well. (5 points)*Brainstorm the above and list the ENTITIES the tutoring company will need to keep track of (5 points)*Brainstorm the above and list the ATTRIBUTES the tutoring company will need to keep track of per Entity, explain any CONSTRAINTS there might be on the attributes, identify PK and FK attributes. (5 points)*Brainstorm the above and list what form of relationships each ENTITIES will have with one another (5 points)*Brainstorm the above and list the CARDINALITY between the ENTITIES (30 points)*Finally, create the Logical (15 points) and Physical (15 points) ERD for this scenario ______________________________________________________________________________ __ 2. (50 points) A new veterinary clinic will like to set up their database. The clinic will like to keep record of their customers such as: pet name, pet type, pet age, pet weight, owner name, owner address, owner contact. Also the clinic will like to keep track of the veterinarian name, specialty and schedule. They will like to keep track of the customer appointment date, what the appointment is for, and how much it will cost. (5 points)*Brainstorm the above and list the ENTITIES the clinic will need to keep track of (5 points)*Brainstorm the above and list the ATTRIBUTES the clinic will need to keep track of per Entity, explain any CONSTRAINTS there might be on the attributes, identify PK and FK attributes. (5 points)*Brainstorm the above and list what form of relationships each ENTITIES will have with one another (5 points)*Brainstorm the above and list the CARDINALITY between the ENTITIES (30 points)*Finally, create the Logical (15 points) and Physical (15 points) ERD for this scenario ______________________________________________________________________________ 3. (50 points) A hair salon will like to set up their database. They will like to keep track of their customers (you can decide on what information to keep track of for the customers). They will like to keep track of their stylists (you can decide what information to keep track of for the stylists). They will like to keep track of the schedule between the customers and the stylists. (Payment information is not needed). (5 points)*Brainstorm the above and list the ENTITIES the salon will need to keep track of (5 points)*Brainstorm the above and list the ATTRIBUTES the salon will need to keep track of per Entity, explain any CONSTRAINTS there might be on the attributes, identify PK and FK attributes. (5 points)*Brainstorm the above and list what form of relationships each ENTITIES will have with one another (5 points)*Brainstorm the above and list the CARDINALITY between the ENTITIES (30 points)*Finally, create the Logical (15 points) and Physical (15 points) ERD for this scenario Upon completion of this exam, please follow these steps: 1. Save your word doc to the desktop using the following naming convention: “ITD256_Midterm_yourname 2. Click the “Choose File” link at the bottom of this exam page in Canvas 3. Choose your word doc from the desktop 4. Click Submit Quiz
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
