Write sql create table statement to create pet table

Assignment Help PL-SQL Programming

Reference no: EM1351857

Q1) Use the following tables for your answer to the question below:

PET_ OWNER ( OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail)
PET ( PetID, PetName, PetType, PetBreed, PetDOB, OwnerID) Sample data for these tables are shown in Figures 3-15 and 3-16 on page 181 of your textbook. For each SQL statement you write, show the results based on these data. If possible, run the statements you write for the questions that follow in an actual DBMS, as appropriate, to obtain results. Name your database Pet- Database. Use data types that are consistent with the DBMS you are using. If you are not using an actual DBMS, consistently represent data types by using either the SQL Server, Oracle Database, or MySQL data types shown in Figure 3.5 on pages 110 and 111 of your textbook.

Write an SQL CREATE TABLE statement to create the PET table without a referential integrity constraint on OwnerID in PET. Justify your choices of column properties. Why not make every column NOT NULL? Write SQL Statements to insert the data in Figure 3-16 on page 181 of your textbook into the PET table.

Reference no: EM1351857

Questions Cloud

Explain what strategies should the argentina division employ : Explain what strategies should the Argentina division employ to capture market share and What strategies would a division of your camera company employ to meet the goals established by your corporation.

What is the net work done on the projectile : The light ray makes an angle of α = 32.1° with the normal line at the boundary of linseed oil and water. find the angles θ1 and θ2. Note that n = 1.48 for linseed oil.

Find the amount of goodwill : Jack corporation paid $800,000 for all of Ann company issued and outstanding common stock. Ann's recorded assets and liabilities on April 1, 20X2, were as follows:

Show importance of employee benefit plans : Importance of providing employee benefit plans to employees working in the chosen positions which are director of IT and the IT help desk.

Write sql create table statement to create pet table : Write an SQL CREATE TABLE statement to create the PET table without referential integrity constraint on OwnerID in PET.

Scheme of the theory on infant development : Where do you think Freud's Id, Ego, and Super-Ego enter the scheme of his theory on infant development?

Relationships in travel & tourism and hospitality industry : Examine the relationship among the different hospitality business segments in Las Vegas. Do the different business segments within Las Vegas support one another?

Elucidate how much do dairy farmers receive per gallon : What is the new equilibrium price and quantity. Elucidate how much do dairy farmers receive per gallon of milk after the tax? how much do demanders pay.

How much time passes before it hears an echo : A parallel-plate air-filled capacitor having area 44.0 cm2 and plate spacing 2.80 mm is charged to a potential difference of 620. V.

User Account

All Pages