Task1
Write down a query which create a table “Persons” with the following fields.
P_Id |
LastName |
FirstName |
Address |
City |
123 |
Ibragivov |
Erlan |
Ibraeva sreet |
Petropavl |
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
Материалы на данной страницы взяты из открытых источников либо размещены пользователем в соответствии с договором-офертой сайта. Вы можете сообщить о нарушении.