5Computer Science_10_Information Systems
Оценка 4.6

5Computer Science_10_Information Systems

Оценка 4.6
docx
09.05.2020
5Computer Science_10_Information Systems
5Computer Science_10_Information Systems.docx

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

 


 

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

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

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

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

Table 1. Countries Table 2

Table 1. Countries Table 2
Скачать файл