Now, in the order given below, make some modifications and populate your tables. Before you start...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Now, in the order given below, make some modifications and populate your tables. Before you start below, make sure your initial code is run. The code is provided in BB. You should drop the tables first. Note, make dates appear as given below. 1. Because you forgot when you created your initial tables, do the following (NOTE: do not change CREATE table commands; the below are modifications): a. Add three fields to the faculty table: hire date (gives the day, month, and year of hiring) teach exper (gives number of months and years of college teaching experience) ave teaching (gives the average time a teacher teaches per year in days, hours, and minutes) b. Add a field to the student table that records a student's class and constrains that class to only FR, SO, JR, SR, or OT (for other). c. Add a constraint that a faculty member's pin must not be null (do not change the table creation above to do this!). I 2. Insert the following records into the tables in an appropriate order. Location (note: locations with 4 or less capacity are offices): # 200 BSA Room 100 Capacity: 35 Capacity: 45 # 201 BSA Room 201 LA's Room 45 Capacity: 50 BSA Room 210 Capacity: 1 BSA Room 211 Capacity: 2 LA's Room 114 Capacity: 4 #210 # 301 # 302 # 444 Faculty (if not tenured, the tenure start date is the exactly one year after the date hired. This date should be in the following format: 2005 JUNE 12). # 13579 Ralph B. Kinner (tenure date: 12 Jun 2003) pin: 98765432 office: BSA 210 teaching exp: 5years, 6mo teaching time: 98 days, 6 hours, 5 minutes #24681 James Cotton (untenured) pin: 34567891 office: BSA 211 Date hired: 4/30/2001 teaching exp: 3years, 10mo teaching time: 188 days, 16 hours phone # 501 339-5674 #36925 Blaine Cultra (tenure date: 18 May 1999) pin: 78901234 office: BSA 211 Date hired: 7/31/1996 teaching exp: 15years, teaching time: 52 days # 24866 Anne L. Masters (untenured) pin: 77553311 office: LA's 114 Date hired: 6/15/2004 teaching exp: 0 years, 9mo teaching time: 101 days, 19 hours Sam T. Chan (adjunct) pin: 34567890 office: LA's 114 Phone: (501) 450- Hire date: 6/10/2018 teaching experience: 2 years 0 months. #45678 2234 Student (all are from Texas): # 56782 # 90123 #34567 #78901 # 90148 advisor: Cotton advisor: Cotton JR advisor: Kinner advisor: Masters FR Grad student advisor: Cultra Hire dates: Tenure dates: Tenure start dates: JR SO Albert C. Bell phone: 432-556-0945 Blair Burton phone: 432-556-6384 Basel Moncrief Anne A. Archer 432-675-3049 John C. Calhoun pin: 55667788 Dates: the following emphasizes the different required date formats: 7/10/2002 10 Jul 2002 2002 JUNE 10 This homework continues our look at the community college at which we are the DBA. We created five tables so far, the SQL code is provided in Blackboard (ModifyInsertHW2Start). Run this script (it will work). TURN THIS IN as a sal file IN BLACKBOARD! Now, in the order given below, make some modifications and populate your tables. Before you start below, make sure your initial code is run. The code is provided in BB. You should drop the tables first. Note, make dates appear as given below. Now, in the order given below, make some modifications and populate your tables. Before you start below, make sure your initial code is run. The code is provided in BB. You should drop the tables first. Note, make dates appear as given below. 1. Because you forgot when you created your initial tables, do the following (NOTE: do not change CREATE table commands; the below are modifications): a. Add three fields to the faculty table: hire date (gives the day, month, and year of hiring) teach exper (gives number of months and years of college teaching experience) ave teaching (gives the average time a teacher teaches per year in days, hours, and minutes) b. Add a field to the student table that records a student's class and constrains that class to only FR, SO, JR, SR, or OT (for other). c. Add a constraint that a faculty member's pin must not be null (do not change the table creation above to do this!). I 2. Insert the following records into the tables in an appropriate order. Location (note: locations with 4 or less capacity are offices): # 200 BSA Room 100 Capacity: 35 Capacity: 45 # 201 BSA Room 201 LA's Room 45 Capacity: 50 BSA Room 210 Capacity: 1 BSA Room 211 Capacity: 2 LA's Room 114 Capacity: 4 #210 # 301 # 302 # 444 Faculty (if not tenured, the tenure start date is the exactly one year after the date hired. This date should be in the following format: 2005 JUNE 12). # 13579 Ralph B. Kinner (tenure date: 12 Jun 2003) pin: 98765432 office: BSA 210 teaching exp: 5years, 6mo teaching time: 98 days, 6 hours, 5 minutes #24681 James Cotton (untenured) pin: 34567891 office: BSA 211 Date hired: 4/30/2001 teaching exp: 3years, 10mo teaching time: 188 days, 16 hours phone # 501 339-5674 #36925 Blaine Cultra (tenure date: 18 May 1999) pin: 78901234 office: BSA 211 Date hired: 7/31/1996 teaching exp: 15years, teaching time: 52 days # 24866 Anne L. Masters (untenured) pin: 77553311 office: LA's 114 Date hired: 6/15/2004 teaching exp: 0 years, 9mo teaching time: 101 days, 19 hours Sam T. Chan (adjunct) pin: 34567890 office: LA's 114 Phone: (501) 450- Hire date: 6/10/2018 teaching experience: 2 years 0 months. #45678 2234 Student (all are from Texas): # 56782 # 90123 #34567 #78901 # 90148 advisor: Cotton advisor: Cotton JR advisor: Kinner advisor: Masters FR Grad student advisor: Cultra Hire dates: Tenure dates: Tenure start dates: JR SO Albert C. Bell phone: 432-556-0945 Blair Burton phone: 432-556-6384 Basel Moncrief Anne A. Archer 432-675-3049 John C. Calhoun pin: 55667788 Dates: the following emphasizes the different required date formats: 7/10/2002 10 Jul 2002 2002 JUNE 10 This homework continues our look at the community college at which we are the DBA. We created five tables so far, the SQL code is provided in Blackboard (ModifyInsertHW2Start). Run this script (it will work). TURN THIS IN as a sal file IN BLACKBOARD! Now, in the order given below, make some modifications and populate your tables. Before you start below, make sure your initial code is run. The code is provided in BB. You should drop the tables first. Note, make dates appear as given below.
Expert Answer:
Related Book For
Accounting Information Systems
ISBN: 9780132871938
11th Edition
Authors: George H. Bodnar, William S. Hopwood
Posted Date:
Students also viewed these programming questions
-
Explain how "noise traders" can undermine the activity of arbitrageurs. Why is this important?
-
To demonstrate the ability to propose, implement, and query the database. Problem: MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona....
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
What is a Java package, and what is its purpose?
-
What are common book-tax differences relating to corporate charitable contributions? Are these differences favorable or unfavorable?
-
Why is an assumed prepayment speed necessary to project the cash flow of a pass-through?
-
What is the definition of current liabilities? Why is it important to distinguish between current and long-term liabilities? LO 8
-
Laser Cast, Inc., manufactures color laser printers. Model A200 presently sells for $400 and has a total product cost of $320, as follows: Direct materials $230 Direct labor ...... 60 Factory...
-
1 . 2 REQUIRED Study the information given below and determine the cost ( as a percentage, expressed to two decimal places ) to Tissot Traders of not accepting the discount. INFORMATION ( 5 marks )...
-
Using the format presented in Figure 2-4 in the text develop a flowchart for the process of paying vendor accounts payable. Assume that vendor invoices are received and sent to the AP department...
-
On August 1, 2021, Trico Technologies, an aeronautic electronics company, borrows $19.9 million cash to expand operations. The loan is made by FirstBanc Corp. under a short-term line of credit...
-
Many businesses borrow money during periods of increased business activity to finance inventory and accounts receivable. For example, Min Corporation builds up its inventory to meet the needs of...
-
Fuzzy Monkey Technologies, Inc., purchased as a long-term investment $160 million of 8% bonds, dated January 1,on January 1, 2021. Management intends to have the investment available for sale when...
-
A. State the five specific transaction-related audit objectives for cash receipts and describe one common test of controls for each objective. B. Discuss what is meant by a proof of cash receipts,...
-
Situation In June 2011, Alabama HB 56, the Beason-Hammon Alabama Taxpayer and Citizen Protection Act, an anti-illegal immigration bill, was signed into law. It faced multiple legal challenges, and...
-
The inventory in a warehouse contains 308 tablets of which 3 are defective. What is the probability that a randomly selected tablet is defective? Round your answer to four decimal places
-
How would your answer change if you were analyzing your own household?O A. If you were analyzing your own household you would not use the accounting equation to perform your analysis.O B. If you were...
-
Fred Farmer needs to prepare a balance sheet for his bank. He spent the day getting the following information. Fred needs your help to build a balance sheet and evaluate it. The information was...
-
Roadco Company has been hired to collect tolls for the Blue Ocean toll road. Robert Asphalt, the controller of Roadco, has been analyzing the situation and has come up with the following pieces of...
-
Figure is an incorrectly prepared business process diagram(BPD). Operations Accounte RelGeneral Ledger | invoice custmer Customer Purchase Order | Post to Customer Account _ Sales Order Update Genera...
-
A medium- sized grocery store has point- of- sale cash registers. The cash registers automatically summarize sales of all items sold in the store. One major problem facing the store is that of...
-
Continuation of SI 0-3: inventory, purchases, and cost of goods sold (Learning Objective 2) In SI0-3, Grippers expects cost of goods sold to average 65% of sales revenue and the company expects to...
-
Sales Budget (Learning Objective 2) In a series of Short Exercises, you will prepare parts of the master budget for Grippers, which sells its rock-climbing shoes worldwide. We will concentrate on...
-
Revise inventory, purchases, and cost of goods sold budget (Learning Objective 4) Refer to the original Whitewater Sporting Goods Data Set item 5. Suppose cost of goods sold averages 75% of sales...
Study smarter with the SolutionInn App