Question
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
Essentials of Database Management
Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman
1st edition
133405680, 9780133547702 , 978-0133405682
