L script which is the physical design for this database ### Animals This table contains the following data about all animals in the zoo. - animal ID (primary key) - animal name - animal birthdate - species - habitat (foreign key) [1 habitat to many relationship] ### Habitats This table contains data about the habitats in the zoo. Each animal lives in a specific habitat. The habitat table should include the following data - habitat name, foreign key) - habitat location ### Database CREATE DATABASE zoo;
SQL script which is the physical design for this
### Animals
This table contains the following data about all animals in the zoo.
- animal ID (primary key)
- animal name
- animal birthdate
- species
- habitat (foreign key)
[1 habitat to many relationship]
### Habitats
This table contains data about the habitats in the zoo. Each animal lives in a specific habitat. The habitat table should include the following data
- habitat name, foreign key)
- habitat location
### Database
CREATE DATABASE zoo;
Write queries to create the tables. Be sure to include primary keys for each table and the required foreign keys and referential integrity actions.
Add appropriate indexes. This database requires at least 2 indexes in addition to those automatically created by MySQL.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
