5Computer Science_10_Information Systems

Task1

Write down a query which create a table “Persons” with the following fields.

Write down a query that was used to insert data into the table “Persons”

Write down a query which delete all records from the table “Persons”.

What software is used for administering MySQL DBMS?

Task2

Provide execution instructions with criteria

Task 3

In the “Phones” database construct the queries for next cases:

1. Query that for adding several contracts to one customer and create a query to display the total number of contracts for each customer

2. Parametric query for displaying the Surname, Phone numbers and Home address of customers, having a contract for the specified date

3. Query that displays information about the number of Purchased phones by the specified client

4. Query that creates a "PhonesClassicAristo" table, which contains information about the phones "Classic" and "Aristo". The table should contain the following fields: Name, Weight, Price, Stock_level

5. Query that updates table "PhonesTable" by reducing prices to 15%

6. Query that removes a client from the database by its code

Task4

1.      Operations on Database.

a)      Create 2 tables in MS Access                                                            

b)      Make a query on Country table:

1)      All countries with population over than 45 million people

2)      All countries which ends with “stan”

3)      All countries which area is greater than 2600000 and Country ID has “z” 

4)      All countries which names starts include “u” or date of independence was before 1960.

c)      Create a relationship between the tables by fields Country ID.

Table 1. Countries

Table 2. Cities