IT Academy - Data Science with Python

S17 T01: Database

Description

reate a relational model and entity-relationship diagram.

Level 1

• Exercise 1

Create a sample relational database using a text or handwritten document. Design it to contain the following tables, and establish the relationships you deem necessary between them:

• Table of purchases (transactions)

• Table of establishments

• Table of workers

• Table of clients

• Table of products

• Product type table

Defines the properties of the relationships (1: 1, 1: n, n: n), and create some of the variables that could contain, for example:

Table of establishments

• IDestabliment (unique key)

• Nom

• Location

• Surface

Level 2

• Exercise 2:
  • Use an entity-related diagram creation program at http://dia-installer.de to create the diagram.

Level 3

• Exercise 3:
  • Use the MySQL Workbench to create a relational model.

Targets

• Construct entity-relationship and relational diagrams
• Use different software for the entity-relationship diagram