Cash-back offer from April 23rd to 27th, 2024: Get a flat 10% cash-back credited to your account for a minimum transaction of $50.Post Your Questions Today!

Question Details Normal
$ 5.00

ISM coding not sure what I've done wrong

Question posted by
Online Tutor Profile
request

 

The following restrictions on the data were discussed in the initial meeting:

- Customer Height will be measured in inches

- Sport Type is either basketball, hockey, football, or soccer

- Food Type is either drink, snack, or main dish

- Restaurant Type is either concession stand or sit down restaurant

- The Departments are Ticketing, Food Service, Gift Shop, Maintenance, and Security

- Multiple food orders occurred on March 17th, 2020.

- All events and orders occurred in 2020.

 

 

Implement the database in MySQL. Specifically, write a SQL script to do the following:

a. Create the Tables. Each Table must have a Primary Key constraint, Foreign Key

constraints where applicable, and other constraints as written in the table

instance charts.

 

the below code is wrong what did I do wrong

reate table Customer(CustomerID INTEGER(7) not null, C_FName varchar(20) not null,C_Lname  varchar(30) not null,C_Height INTEGER(7) not null,SeasonPass_ID INTEGER not null,primary key(CustomerID) ,foreign key(SeasonPass_ID) references SeasonPass(SeasonPassID) );

Available Answers
$ 15.00

[Solved] ISM coding check attached sql files

  • This Solution has been Purchased 1 time
  • Average Rating for this solution is A+
  • Submitted On 24 Apr, 2017 07:55:50
Answer posted by
Online Tutor Profile
solution
ISM coding check attached s...
Buy now to view the complete solution
attachment
Attachment
Other Related Questions

No related question exists

The benefits of buying study notes from CourseMerits

Assurance Of Timely Delivery
We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.
Best Price In The Market
All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.
Uninterrupted 24/7 Support
Our customer support wing remains online 24x7 to provide you seamless assistance. Also, when you post a query or a request here, you can expect an immediate response from our side.
closebutton
Only 45 characters allowed.
closebutton

$ 629.35