The design that you implement for you database will be based on the data dictionary and the entity-relationship diagram. You need to be able to take design and check that this matches the database created.
Each SQL operation should be tested to ensure that they produce the expected results, including INSERT, DELETE and UPDATE.