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?
Provide execution instructions with criteria
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
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
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
Operations on Database.
Create 2 tables in MS Access
Make a query on Country table:
countries with population over than 45 million people
countries which ends with “stan”
countries which area is greater than 2600000 and Country ID has
countries which names starts include “u” or date of independence was
Create a relationship between the tables
by fields Country ID.
Table 1. Countries
Table 2. Cities
© ООО «Знанио»