Exercises (E4) pages 131–138
E4.1 Create an example of a relation (containing several records) that is prone to update anomalies.
E4.3 Using the relation created in exercise E4.1, describe an example that illustrates the deletion anomaly.
The questions are in this book: Jukić, Vrbsky, Nestorov, and Sharma, Database Systems: Introduction to Databases and Data Warehouses, 2nd ed., Prospect Press, 2021. ISBN 978-1-943153-67-1.
Next comes the data entry:
Make up data for your database, or find real data.
You can enter the data with INSERT statements, but it is much easier to use PhpAdmin. It has a form where you can type the data directly (see screenshot). Alternatively, you can use PhpAdmin to import CSV data (comma-separated values), which you can export from Excel.
Include at least 3 rows in each of the entity relations, and as many rows as you need to represent the relationships.
When your database is complete, export the entire schema (the database with the data) using PhpAdmin. It should create one large .SQL file, which is just a text file with SQL code in it. Take a look at it. It must include all of the following:
CREATE TABLE statements for all the tables
Primary keys and foreign keys (usually part of create table)
INSERT statements for all the data
Upload the SQL file to Canvas. It is due by the date posted on Canvas.
. Part 1: Exercises (E4) pages 131–138 E4.1 Create an example of a relation (c