Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2. (10 points) Using the SQL Emulator Create a Table named Pet (case counts). Use the Table below for the columns specifications. Your answer should
2. (10 points) Using the SQL Emulator Create a Table named Pet (case counts). Use the Table below for the columns specifications. Your answer should include a screenshot of what the emulator provided (The Red Box).
Column Name | Column Type | Primary Key | Not Null | Comment |
PetID | Integer | Yes | Yes | The highest pet id will be 9999 |
OwnerId | Exactly 7 characters | Yes | Yes | The id of the pets owner |
TypeID | Integer | Yes | Yes | References the Type Table |
PetName | Maximum 30 characters | No | No |
|
Description | Maximum of 50 characters | No | No |
|
Birthday | Date | No | No |
|
LastVisit | Date | No | No |
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started