Reference no: EM131036655
Creating the database schema, use Insert, Update, and Delete commands
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:
NameEmailFred [email protected] [email protected] [email protected]
3. Insert the following students' records:
NameBirthdateGenderStartDateGPAIsActiveBioAdvisorIDCraig Franklin1970-03-15Male2010-05-303.10Yes 3Harriet Smith1982-04-15Female2010-05-303.22Yes 1George David1984-11-05Male2010-10-010.00Yes 3Ben 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 Homework 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. Give an introduction explaining the essential of these commands in relation to your overall Key Homework.
|
Write comparative report on methodology all parties followed
: Task: Read the ruling in both the Mittal Steel and SCI case and write a comparative report on the methodology all the parties followed in their assessment of excessive pricing. In your report specifically address the following: Factors assessed to..
|
|
Aggregate demand and real gross domestic product
: the price level will drop.b. aggregate demand and real Gross Domestic Product (GDP) will not change.c. aggregate demand and real Gross Domestic Product (GDP) will increase by the amount of the spending increase.d. the government spending multiplie..
|
|
Why was that moment significant
: After watching the video at http://www.youtube.com/watch?v=zT7TeryDzk0&feature=player_detailpage, consider how over time, the practice of psychology has become more widely accepted. What was one of the defining moments in the history of psycholog..
|
|
International macroeconomics report
: For this report, you will use the concepts that you have learned about macroeconomics and apply them to another country's economy. You may choose any country except the US or your home country (if it is other than the US), in order to demonstrate..
|
|
Create database schema use insert update and delete commands
: Creating the database schema, use Insert, Update, and Delete commands. After creating the database schema, use Insert, Update, and Delete commands to populate the tables with the following information.
|
|
Draw a timing diagram for the handshaking transfer
: Draw a timing diagram for the handshaking transfer. c. Obtain a sequence-of-events flowchart for the transfer from the device to the interface and from the interface to the CPU.
|
|
Analysis of labor markets-policy memo on minimum wage
: Read the relevant sections in the Borjas book on minimum wages. Read the policy memo by Arindrajit Dube titled "Designing Thoughtful Mini- mum Wage Policy at the State and Local Levels". (Posted on D2L)
|
|
Interpreting bad debt disclosures
: Daimler chrysler is the largest industnal group headquartered in Germany Best known as the manufactures of Mercedes-benz and Chrysler ems and trucks, it also manufacture products in the held of rail systems. aerospace. propulmon, defense, and tnfo..
|
|
Determine the mass of each of the two cylinders
: determine the mass of each of the two cylinders if they cause sag of s=0.5 when suspended from the rings a A and B.Note that s=0 when the cylinders are removed
|