Assignment:
Create a 5-page MS Word document following APA guidelines (first person should not be used). Write this document for a technical audience.
Research and answer the following components:
Integrity Constraints
Explain each of the following and provide examples:
- Domain Constraints
- Entity Integrity
- Referential Integrity
SQL. Design a basic database with at least two tables (e.g., Pet Grooming Customer Database). For your specific database:
- Briefly explain the purpose of the database. Provide a visual representation of your database's tables.
- Write an SQL statement to create a table.
- Write an SQL statement to add a record.
- Write an SQL statement to edit a record.
- Write an SQL statement to delete a record.