Поделиться
Formative assessment.docx
Name: ______________________________ Grade: _________
Formative assessment.
Learning objective: 10.3.2.2 create a single-table database (SQL);
Assessment criteria:
Knowledge and understanding:
- to know queries for creating and working with single-table database;
Applying:
- write a query to create a single-table database;
Task:
1. 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 |
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
_______________________________________________________________ [3]
2. Write down a query that was used to insert data into the table “Persons”
__________________________________________________________________
_______________________________________________________________ [3]
3. Write down a query which delete all records from the table “Persons”.
_______________________________________________________________ [1]
4. What software is used for administering MySQL DBMS?
_______________________________________________________________ [1]
Mark scheme:
|
Question |
Answer |
Comments |
|
1 |
CREATE TABLE Persons
(
|
1 mark for “CREATE TABLE Persons ”, 1 mark for correct fields, 1 mark for correct data types |
|
2 |
INSERT INTO Persons (P_Id, LastName, FirstName, Address, City ) VALUES (123,"Ibragivov", "Erlan","Ibraeva sreet", "Petropavl); |
1 mark for “ INSERT INTO Persons ”, 1 mark for correct fields, 1 mark for correct values
|
|
3 |
DELETE FROM Persons; |
|
|
4 |
PhpMyAdmin |
|
Материалы на данной страницы взяты из открытых источников либо размещены пользователем в соответствии с договором-офертой сайта. Вы можете сообщить о нарушении.
