Question: Write primary and foreign keys for all tables if exists. Please write the answers properly. Productline Y ID integer (10) DescInText varchar(255) DescInHTML varchar(255) Image

Write primary and foreign keys for all tables if exists. Please write the answers properly.

Write primary and foreign keys for all tables if

Productline Y ID integer (10) DescInText varchar(255) DescInHTML varchar(255) Image varchar(100) Product Code integer (10) F----04 Productinel integer(10) Name varchar(255) Scale integer(10) vendor varchar(255) Pdt Description varchar(255) QtyInStock integer(10) Buy Price numeric19,0) MSRP varchar(255) Order_Product ID integer (10) OrderID integer(10) ProductCode integer (10) Qty integer(10) PriceEach numeric(19,0) Employee ID integer (10) OfficeCode integer(10) reports to integer(10) LastName varchar(255) FirstName varchar(255) Extension varchar(255) Email varchar(255) Job Title varchar(100) Order ID integer (10) CustomerID integer(10) Order Date date RequiredDate date ShippedDate date Status integer(10) Comments varchar(255) F----04 Customer ID integer (10) sales RepEmployeeNum integer(10) Name varchar(255) LastName varchar(255) FirstName varchar(255) Phone varchar(255) Address1 varchar(255) Address2 varchar(255) City varchar(255) State varchar(255) Postal Code integer(10) Country varchar(255) CreditLimit numeric(19,0) F---- Payment y CheckNum varchar(255) Customerid integer(10) PaymentDate date Amount numeric(19,0) + Office Code inte ger(10) City varchar(255) Phone varchar(255) Address1 varchar(255) Address2 varchar(255) State varchar(255) Country varchar(255) PostalCode integer (10) Territory varchar(200)

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 General Management Questions!

Introduction to databases FALL 20 Assignment III Based on the database schema that was used in assignment I, answer the following questions: 1. Write the business rules that are reflected by the...

MySQL Q.6) (25 points) You have been notified that Fender Guitars has discontinued their 'Fender Stratocaster' Guitar and that you will no longer carry it in your inventory. As a result, you need to...

Required information [The following information applies to the questions displayed below] Complete the following questions by selecting the appropriate options listed below. Write out a set of...

MySQL You have been notified that Fender Guitars has discontinued their 'Fender Stratocaster' Guitar and that you will no longer carry it in your inventory. As a result, you need to remove this item...

*Lab 6 is there in case you don't know what "Lab 7" instructions are referring to when they say" Lab 6." Lab 7 is the one that needs to be done. Lab 7: Inserting and Updating Data OVERVIEW This lab...

This practice lab provides you the opportunity to create tables, primary keys and foreign keys with the use of SQL commands. The lab will utilize the FLIX2YOU problem. (In Microsoft SQL studio) In...

24 pts Consider the following database schema, and for each entity, identify any primary and/or foreign keys. If there is more than one value, write both, separated by a comma (or commas). If none,...

Q2.) (25 points) Use the om database for this question. Write a query that replicates the result set below, matching all data and format aspects, including column headers. For this question, you must...

I need some assistance with my project proposal and its overview, my systems analysis and entity-relation diagram(ERD) and overall database creation. I am using Microsoft Visio and MS SQL 2012 as...

MIS 3 3 0 6 Database Management Systems Module 3 Exercise 4 0 points Required for Grading: I am ( type your full name ) and I complete this assignment following the UHD academic integrity policy. ( 5...

Azulene, an isomer of naphthalene, has a remarkably large dipole moment for a hydrocarbon (? = 1.0 D). Explain, using resonance structures. Azulene

Why would different industries have different degrees of economies or diseconomies of scale?

When a job is completed, the goods are transferred from the production department to the finished goods warehouse and the journal entry would include a debit to Work in Process. Group startsTrue or...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...