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

Link the tables

Week 18 · 2.3 Creating databases · 3 lessons
Answers are for parents and teachers.
1
A garden club keeps one table with these columns: Visit_ID, Member, Member_phone, Plot. Member Tara appears in four rows. Describe one problem that this causes.
2
Split the garden club’s table into two tables. Name each table, list its fields, and mark the primary key and the foreign key.
Visit_IDMemberMember_phonePlot
1Tara555-0410Herb bed
2Joe555-0433Pond side
3Tara555-0410Bean rows
4Tara555-0410Herb bed
3
A Pets table has the fields Owner_ID, Owner_name and Pet_name. Which field is the best primary key, and why? Write the data type of each field.
4
Study the CSV text. State the number of records and fields, and write the data type of Price and of Hot.
Csv
1Drink,Price,Hot
2Tea,1.20,Yes
3Juice,2.00,No
4Cocoa,1.80,Yes
5Water,0.90,No
5
In this table, how many records match Price > 1.50, and how many match Price > 1.50 and Hot = Yes? Name them.
DrinkPriceHot
Tea1.20Yes
Juice2.00No
Cocoa1.80Yes
Water0.90No