Question: What SQL script (either MySQL or SQL Server) will create a database named CouponMgr? Dont worry about all the options; just enough to create the

What SQL script (either MySQL or SQL Server) will create a database named CouponMgr? Dont worry about all the options; just enough to create the database.

2. What SQL script (either MySQL or SQL Server) will create a table named Coupons in the CouponMgr databaser? CouponID -- an integer -- is the primary key, IssuedTo -- 15 or less characters of text -- and CouponAmount -- Money or two place decimal value -- are the columns. Dont worry about all the options; just enough to create the table.

3. What SQL script (either MySQL or SQL Server) will insert a record with a CouponID of 1234, IssuedTo equal to your GRU login ID, and CouponAmount equal to $1000 plus the last three digits of your student number? Dont worry about all the options; just enough to create the record.

4. What SQL script (either MySQL or SQL Server) will return all records (with all columns) from the Coupons table?

5. What SQL script (either MySQL or SQL Server) will delete all records (with all columns) from the Coupons table (but leave the empty table)? What SQL will remove the table entirely?

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!

For this set of Review Questions, we will create and use a database for the Wedgewood Pacific Corporation (WPC) that is similar to the Microsoft Access database we created and used in Chapters 1 and...

* Requirements Specification ( this is a fictional scenario ) A fitness company stores the current assignments of trainers to customers in a document file like this: * Trainer: Jones, William; phone...

This assignment teaches you how to implement a database containing a hierarchy and ask queries containing aggregate operators and subqueries, starting with a specification. You must continue the...

This case study assignment is based on (but not same as) the Queen Anne Curiosity Shop (QACS) Case Questions at the end of Chapters 7 and 8. Since there are important differences between the...

James Morgan owns and operates Morgan Importing, which purchases antiques and home furnishings in Asia, ships those items to a warehouse facility in Los Angeles, and then sells these items in the...

Assume that The Queen Anne Curiosity Shop designs a database with the following tables: CUSTOMER (CustomerID, LastName, FirstName, Address, City, State, ZIP, Phone, Email) EMPLOYEE (EmployeeID,...

!!!!!!!!!!!!!!! Complete the practice exercise by drawing the three separate diagrams for HSD and create one document containing all three diagrams (a, b, and c). !!!!!!!!!!!!!!!!!!! HEATHER SWEENEY...

Consider the January transactions for Davis Consulting that were presented in Chapter 5. (Cost data have been removed from the sale transactions.) Davis uses the perpetual inventory system. Jan. 2...

In simple random sampling, we know that a without-replacement sample of size n has smaller variance than a with replacement sample of size n. The same result is not always true for...

Lela was a widow at her death in 2 0 2 5 . She died with a gross estate of $ 1 4 , 7 3 5 , 0 0 0 , consisting entirely of publicly traded income - producing stock. Her debts were $ 7 5 , 0 0 0 , and...

I need to write a program that implements this Algorithm (image below) on C++. It needs to accept binary matricies from std in and it needs to prove whether it is a equvalence relation (whether the...

1 Suggest how global and regional supply chain groups work together. Our confectionery business is organised into four business segments which we call regions, and six global functions, as depicted...

The international logistics pipeline, shown in Figure 4.3, is made up of the same basic elements as any other pipeline. However, this pipeline has a number of special characteristics. Use Table 4.3...

1 Comment on Glups plans to create engineered costs from the perceived benefits of the new material-handling equipment. Glup SA supplies a range of household soaps to supermarkets in northern Europe....