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