Create a view that finds the student name, Database Management System

Section A:  Use the following tables to create a database called College.  Use SQL commands.

Student

stuid(primary)

lastName

firstName

major

credits

S1001

Smith

Tom

History

90

S1002

Chin

Ann

Math

36

S1005

Lee

Perry

History

3

S1010

Burns

Edward

Art

63

S1013

McCarthy

Owen

Math

0

S1015

Jones

Mary

Math

42

S1020

Rivera

Jane

CSC

15

Faculty

facid (primary)

name

department

rank

F101

Adams

Art

Professor

F105

Tanaka

CSC

Instructor

F110

Byrne

Math

Assistant

F115

Smith

History

Associate

F221

Smith

CSC

Professor

Class

classNumber (primary)

facid

schedule

room

ART103A

F101

MWF9

H221

CSC201A

F105

TuThF10

M110

CSC203A

F105

MThF12

M110

HST205A

F115

MWF11

H221

MTH101B

F110

MTuTh9

H225

MTH103C

F110

MWF11

H225

Enroll

stuid

classNumber

grade

S1001

ART103A

A

S1001

HST205A

C

S1002

ART103A

D

S1002

CSC201A

F

S1002

MTH103A

B

S1010

ART103A

 

S1010

MTH103C

 

S1020

CSC201A

B

S1020

MTH101B

A

1.  Create the database College.

2.  Create the table Student.

3.  Create the table Faculty.

4.  Create the table Class.

5.  Create the table Enroll.

6.  Create all foreign keys

Section B:  Using the database in Section A.  Answer all questions.

7. Create a view that finds the student name, major and enrolled in the art class

8. Create a view that finds the student name, and classes enrolled

9. Create a stored procedure that finds the name of faculty and their schedule

10. Create a stored procedure that finds the student names for a particular course.

11.  Create a role called students; give SELECT permission.  Use a cursor to add all students as members of the above.  Setup each student as a user with temporary password of first four letter of last name and add '8888'.

12.  Convert to XML the student table.

Section C:  Using the Halloween database.

13.  Create a table called ProductImages which has the following fields ImageID (int, primary key, identity), productid (varchar), and ImageProduct (varbinary(max)).

Posted Date: 4/2/2013 3:02:44 AM | Location : United States







Related Discussions:- Create a view that finds the student name, Assignment Help, Ask Question on Create a view that finds the student name, Get Answer, Expert's Help, Create a view that finds the student name Discussions

Write discussion on Create a view that finds the student name
Your posts are moderated
Related Questions
Explain the term- Periodic recomputation Periodic recomputation:  Base values are often updated in bunches. Sometimes, it is possible to just recompute all derived attributes p

What is meant by buffer blocks and disk buffer   The blocks residing temporarily in main memory are referred to as buffer blocks. The area of memory where blocks reside t

which component of DBMS can be embedded in a program? The data manipulation language (DML) is a component which is embedded in a program.

Consider the following relational schema: Doctor(DName,Reg_no) Patient(Pname, Disease) Assigned_To (Pname,Dname) Give expression in both Tuple calculus and Domain calculus for

Describe the types of Inheritance 1.  Single inheritance 2.  Multiple inheritance 3.  Hierarchical inheritance 4.  Multilevel inheritance

1.Why we need data mining? Give an example to illustrate your answer. 2. Why data mining is considered as "misleading name"? 3. Distinguish the difference between database an

Candidate Key:  In a relation R, a candidate key for R is a subset of the set of attributes of R, which have the differnt two properties: (1)        Uniqueness:                N

The traffic data mgmt. systems infrastructure plan describes the software, hardware, data network, and other elements that will support the TDMS. The infrastructure plan is based o

What are composite attributes? Composite attributes can be separated in to sub parts.

Write the C++ program having class name studentinfo, that is used to store the VU student information: This class should store your VUID, campus id, name and father name in the fol