Question: 1) Write SQL commands to create the type and type body for an object type called TotalSales that represents the sales of a bookstore. The

1) Write SQL commands to create the type and type body for an object type called TotalSales that represents the sales of a bookstore. The TotalSales type should have: three attributes called book, unitPrice and quantity with respective datatype; and one method called getTotalSales that returns the sales (as DECIMAL). The TotalSales type may not have subtypes.

2) Write an SQL statement to create table BookSales that has TWO (2) attributes: salespersonName of type varchar and SaleAmount of type TotalSales.

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!

a) Write SQL commands to create the type and type body for an object type called TotalSales that represents the sales of a bookstore. The TotalSales type should have: three attributes called 'book',...

Write SQL commands to create the type and type body for an object type called TotalSales that represents the sales of a bookstore. The TotalSales type should have: three attributes called 'book',...

Mysql Team id 11 12 20 21 name hornets lions eagles sharks points 7 4 1 1 Venue id name 1 Nottingham 2 Leicester 6 Nottingham 7 Sheffield VONA Match id teamID venueID 1 opponentID teamPoints 12 3 1...

QUESTION 1: a) Write SQL commands to create the type and type body for an object type called TotalSales that represents the sales of a bookstore. The TotalSales type should have: three attributes...

Car reg No distanceSinceService km PerLitre FF06DDS 122 10 EE07SSA 110 8 FGOZBAK 165 7 HHOSBBW | 0 12 Employee id name 1 Smith 2 Patel 6 Bennett 7 Booch TravelCost journeyId carRegno employeeID...

database management system, pdf is attached COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

This assignment reviews object-oriented programming concepts such as classes, methods, constructors, accessor methods, and access modifiers. It makes use of an array of objects as a class data...

Assignment 3 oh Assignments 3 and 4 will give you practice applying what you learned in module 2 to actually create and query a small database using SQL. You will use a very popular open source...

This assignment reviews object-oriented programming concepts such as classes, methods, constructors, accessor methods, and access modifiers. It makes use of an array of objects as a class data...

Finx, Inc., purchased a truck for $35,000. The truck is expected to be driven 15,000 miles per year over a five-year period and then sold for approximately $5,000. Determine depreciation for the...

ACME Ltd. is authorized to issue 100,000 $2 cumulative preferred shares. The company can issue unlimited common shares, and has 64,500 common shares outstanding worth $245,000 and no preferred shares...

As the raw-materials store manager for MM Manufacturers, you have received and checked the following bin cards for the three raw materials your company uses:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

9. Mohawk Industries Inc.

8. Satyam Computer Services Limited

2. Explain how the role of training is changing.