AdvertisementYour brand could be hereYour brand hereOn every Darslab page · students, parents and teachersinfo@darslab.comAsk for pricesPricesinfo@darslab.com
☰ Year plan · Communication Technology

The database program, the Terms table and SQL

Week 7 · Unit 2 Requirements and Production Stages of the Project (4), Create database tables stage (3): the database program, tables and queries, the Terms table of the dictionary, the four SQL commands · 3 lessons
Answers are for parents and teachers.
1
Write a SELECT that shows only Term and Defe of every record in Terms.
2
Write a command that removes only the term with id 1, and say what the command would do without the WHERE part.
3
A table has the records 1 router, 2 cable, 3 browser. After INSERT with id 4 and DELETE of id 2, which ids are left?
4
Explain why the Picture field holds text and not a picture.
5
Put the commands in a useful order for adding and checking a term: SELECT to check, INSERT to add. Why this order?