SQL for Data Management

FratBro23
Category:
Programming
Price: $40 USD

Question description

After creating the database schema, use Insert, Update, and Delete commands to populate the tables with the following information. Notice that the values for the primary key columns (ClassId in the Classes table, AdvisorId in the Advisors table and StudentId in the Students table) are not listed. It is assumed that they will be “Identity” or “Auto-increment” columns and the DBMS will determine the proper identity value when the row is inserted.

You may have to either modify your original data types for some of your table columns or modify the values below to fit your data types. For example, if you defined your gender column to be a 1-character column, you will need to use the values M or F instead of Male and Female. The IsActive column is another column that may require different values, depending on the type of DBMS used.

1. Insert the following classes' records:

CodeName

Description

ACCT306Accounting 1This course introduces accounting concepts and explores the accounting environment. It covers the basic structure of accounting, how to maintain accounts, use account balances to prepare financial statements, and complete the accounting cycle. It also introduces the concept of internal control and how to account for assets.
CS362Structured Query Language for Data ManagementThis course gives complete coverage of SQL, with an emphasis on storage, retrieval, and manipulation of data.
ENG115English CompositionIn this course, students focus on developing writing skills through practice and revision. Students will examine expository, critical, and persuasive essay techniques.
FIN322InvestmentsThis course focuses on investments and investment strategies. Various investment vehicles such as stocks, bonds, and commodities are examined. Students will explore the principles of security analysis and valuation.

2. Insert the following advisors' records:

NameEmail
Fred Stonefred@college.edu
Bob Gordonbob@college.edu
Jack Simpsonjack@college.edu

3. Insert the following students' records:

NameBirthdateGenderStartDateGPAIsActiveBioAdvisorID
Craig Franklin1970-03-15Male2010-05-303.10Yes3
Harriet Smith1982-04-15Female2010-05-303.22Yes1
George David1984-11-05Male2010-10-010.00Yes3
Ben Jefferson1976-09-25Male2009-02-211.80NoThe student has gone on temporary leave to pursue other opportunities but plans on returning in 1 year.3

4. Delete the course named Investments from the system.

5. Change Harriet Smith’s birthdate to April 25, 1982 and her GPA to 3.25.

Copy and paste the work into your Key Assignment document and include screen shots of each step, describe what you did for each step and paste in the actual SQL text used to perform each step. Provide an introduction explaining the important of these commands in relation to your overall Key Assignment.20141011161223database_creation_1.docx 

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: UC Berkeley
PREMIUM TUTOR
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1829 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors