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

The Answer is in the image, click to view ...

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Using the SQL Emulator prepare SQL statements to perform the following tasks. Each task is worth 10 points. For all tasks show a screenshot of what the emulator provided (i.e., The Red Box). Place...

MySQL My SQL Overview: Database management plays an integral role in nearly every area of business. Databases house customer information, accounting, and employee management, and these different data...

Step Instructions Points Possible 1 0 Start Excel. Download and open the file named e06c1DirecoWarketing.xlsx. Save it as e06c1DirectMarketing_LastFirst.xlsx. Note: You must save the file name...

TASK You are to create a forum website based on the descriptions below, that allows users to sign up and create topics and posts on those topics. SET-UP Create a folder on...

NEED STEP BY STEP PROCESS Exp19_Excel_Ch06_Cap_High_West Fashions_Instructions - Protected View - Saved to this PC References Mailings Review View Help Tell me what you want to do et can contain...

Oracle 12c Joan Casteel. Chapter 4 - Create the SQL statements for ALL the Hands-On Assignments at the end of Chapter 4 (#1 - #10). Combine all of the SQL statements into one .sql file named...

Can you show a step by step way to workout this assignment. A1 Direct Marketing M Direct Marketing 3 Inputs Number of Ads 5 Click Rate 10000 5.OON 7 Parameters 8 Design Fee $ 2.000.00 9 Cost Per Ad S...

please send me solution i need your immediate help thanks Grader. Instruction Exp19_Excel_Ch06_Cap_High_West_Fashions Project Description: You are the digital marketing director for High West...

Stepu Instructions 1 Open the download-file exploring e06 grader Capstone.xisx a 0.000x Create appropriate range names for Total-Production Cost (cell B18) and Gross Profit (cell B21)-by selection,...

Using Porters competitive forces model, analyze the NBAs market situation. How does the use of Akamai help the NBA compete in this market?

Illustrate the effects on the accounts and financial statements of recording the following transactions: a.) Sold merchandise for cash, $23,500. The cost of the merchandise sold was $14,000. b.) Sold...

The most expensive source of long - term funds is ( are ) _ _ _ _ _ _ _ _ _ _ while the least expensive source of long - term funds is ( are ) _ _ _ _ _ _ _ _ _ _ . Group of answer choices existing...

JAVA: Stacks are often used to provide undo support in applications like a Web browser or text editor. While support for undo can be implemented with an unbounded stack, many applications provide...

LO27.5 Discuss the nature and function of a GDP price index and describe the difference between nominal GDP and real GDP.

4. Why do economists include only final goods and services when measuring GDP for a particular year? Why dont they include the value of the stocks and bonds bought and sold? Why dont they include the...

3. Which of the following goods are usually intermediate goods and which are usually final goods: running shoes, cotton fibers, watches, textbooks, coal, sunscreen lotion, lumber? LO27.1