12.8. Assignments Relational Schema

12.8.1. Assignment DB.3.0

Given the following

Figure 12.14. World

Ask the teacher the necessary questions for creating the database worldTest, and for implementing the tables city, country, speaks, and countrylanguage.

When this is succesful, insert your home country into the database. Insert two languages spoken in your country, and insert 4-5 cities as well.

All SQL entered into one text file db31.sql which you will test, and, when it is error free, hand in.