Throughout we will adhere to SQL style conventions, e.g., please see SQL Style Perform further exploration and also visualisation of the data using python. Add primary and foreign key constraints.Īsk questions of the IMDb data, so as to practice simple and more advanced SQL.
Model the database using an Entity-Relationship (ER) diagram.The tangible steps we will take in this project are:ĭesign a relational database and store the IMDb data in it. MySQL directly and also indirectly using python. Practice database querying by posing basic and more advanced queries using Logical schema, and database normalisation. Learn the essentials of database design, e.g., Entity-Relationship diagrams, Learn about and use the database management system MySQL. The purpose of this project is to do the following: The data used in this project was obtained on. (*.tsv) files, which are explained and available for download from The dataset consists of 7 compressed tab-separated-value In this project we will build a MySQL database using the Internet Movie Database
0 kommentar(er)
