INTRODUCTION TO DATA SCIENCE
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
KIT102
INTRODUCTION TO DATA SCIENCE
Assignment
Task
You have been presented with the case study below. You need to turn this into a MySQL database. These are the requirements:
1. Read the case study and develop an Entity-Relationship Diagram using the conventions for this unit. This diagram needs to describe all of the business rules in the case study.
1.Tutorial :history of data models/ the relational model
2. Using this unit’s Entity-Relationship to Relational Schema Algorithm, convert your Entity- Relationship Diagram into a relational schema.
1. Tutorial :history of data models/ the relational model
3. Using MySQL create the database based upon your relational schema.
Sql01
1. Create table receptionist
2. Receptionist smallint(30 not null, /* 40 characters because….*/
3. Name varchar (40) not null
4. Primary key (receptionistID)
5. )
6. Engine=innoDB
4. Enter two records into each of the relations that you have created in your MySQL database.
Sql01
Insert into receptionist values (100,)
Insert into receptionist values (101)
Inserts 3 services
5. Correctly and appropriately comment your code so that it can be maintained by your client.
6. If you are stuck at any stage – speak to your tutor or email your Unit Coordinator for help.