1. Describe a situation in which the database might become inconsistent.
2. How could a relational database ensure date consistency?
3. What are some other potential drawbacks to a flat-file database?
4. Explain how you might restructure this data as a re
Wildoph Avrilien (14162913)
Administering the drugs
Recipient of drug
Threats of outside security
Redundancy- data repeated in multiple places
primary key- constraint that uniquely identifies each row in a table. The PK is repeated in other
tables as a fk in order to make relationships between tables
Find primary key/foreign key and identify