Apply standard techniques to sort, restrict, and manipulate data.
pxmptee
dml_select_and_procedures.docxWhen inserting the advisors records, separate first and lastname as they are separate fields in the table schema.
1. Insert the following classes' records:
|
Code |
Name |
Description |
|
ACCT306 |
Accounting 1 |
This 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. |
|
CS362 |
Structured Query Language for Data Management |
This course gives complete coverage of SQL, with an emphasis on storage, retrieval, and manipulation of data. |
|
ENG115 |
English Composition |
In this course, students focus on developing writing skills through practice and revision. Students will examine expository, critical, and persuasive essay techniques. |
|
FIN322 |
Investments |
This 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:
|
Name |
|
|
Fred Stone | |
|
Bob Gordon | |
|
Jack Simpson |
3. Insert the following students' records:
|
Name |
Birthdate |
Gender |
StartDate |
GPA |
IsActive |
Bio |
AdvisorID |
|
Craig Franklin |
1970-03-15 |
Male |
2010-05-30 |
3.10 |
Yes |
|
3 |
|
Harriet Smith |
1982-04-15 |
Female |
2010-05-30 |
3.22 |
Yes |
|
1 |
|
George David |
1984-11-05 |
Male |
2010-10-01 |
0.00 |
Yes |
|
3 |
|
Ben Jefferson |
1976-09-25 |
Male |
2009-02-21 |
1.80 |
No |
The 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.
Please submit your assignment.
