Chapter 1, Problem 2EYW

Describe how to include SQL CLR functionality into the Visual Studio environment.

Database introduction based question

Student StudentID FirstName LastName Major 1. Please list all entities you see from the above figure

Table name: Products Column Role Data Type Length Constraint Name P ID Stores the ID of a product Number 8. Primary key P Name Stores the name of a product Varchar2 25 P_entryDate Stores the entry date of a product Stores the expiry date of a product Date Cannot be null P_Expiry P Expiry date should be greater than P entryDate Date P Price Stores the price of a product Number 3,2 Cannot be null a) Write in SQL a command that creates the table Products according to the above description (2 marks). b) Write in SQL a statement that adds to the table Products a new column named supplierID of type Number(5). This column should be defined as a foreign key that relates the table Products to the table Supplier (1.5 marks). c) Write in SQL a query that lists all the details of products arranged in descending order according to the entry date (1.5 marks).

ITEM (ITEM ID, DESCRIPTION, ON HAND, CATEGORY, LOCATION, PRICE, NUM, INVOICE _ DATE, CUST PRICE)) (INVOICE ID, FIRST NAME, LAST_ NAME, QUANTITY, QUOTED

List the reasons why an index is only helpful for attributes that have a wide range of values.

Explain the role of a primary key.

List the changes you would need to make to your answer for Question 11 if the requirements change so that you must store the year and the semester in which a student took a course and received a grade.

Which attribute would you designate as the primary key?