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?
-
The temperature within the Earths crust increases about 1.0Co for 3each 30 m of depth. The thermal conductivity of the crust is 0.80 W/Co m. (a) Determine the heat transferred from the interior to...
-
Discuss why Asian Americans continue to be seen as foreigners today. Many Asians report that people ask "Where are you from?" and that "Los Angeles" is often not the answer people are looking for....
-
In Example 17.11, assume that the promised amounts to \(A\) and \(B\) are \(\$ 110\) and \(\$ 90\), respectively. Develop the new table of results. What are the prices of \(A\) and \(\mathrm{B}\) ?...
-
1. Identify any potential threats to judgment you think could exist based on the facts of the case? 2. Thinking back to the biases discussed in Chapter 2, what biases might the identified threat(s)...
-
Case Study Read the FedEx Office Case before you begin this assignment. For this assignment, you will identify and fully analyze a minimum of three problems that the FedEx Office representative can...
-
Answer the following questions related to the Docks Creek Land Company case presented in the chapter: 1. How does Robertsons role differ from Wisemans? 2. Are the professional standards applied...
-
Identify and describe several key activities required for managing cultural diversity, and to what degree do HR professionals believe these activities are beneficial in maintaining a competitive...
-
Unroll the loop below: a. two times b. three times for (i = 0; i < 32; i++) x[i] = a[i] * c[i];
-
Einstein once said that Everything should be made as simple as possible, but not simpler. This perfectly captures the view that accounting standards should be firmly governed by high-level principles...
-
Look up the FASB home page on the Internet at the following address: www.fasb.org. Find the list of technical projects that are currently on the boards agenda. Choose one of the projects that will...
-
An elevator operated by an electric motor rises at a constant speed. What is the work done on the elevator as it rises a distance \(b\) ?
-
About how much work does a trash collector do in the course of an 8-hour shift?
-
Write the complete (total) ionic equation showing the mixture ofaqueous magnesium chloride and aqueous sodium carbonate. (Includestates-of-matter under the given conditions in your answer.) A)...
-
SCHEDULE OF COST OF GOODS MANUFACTURED The following information is supplied for Sanchez Welding and Manufacturing Company. Prepare a schedule of cost of goods manufactured for the year ended...
-
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...
-
Do the assumptions for Bernoulli trials appear to hold? Explain. If the assumptions hold, identify success and the probability of interest. (a) A TV ratings company will use their electronic...
-
Use Table 1, or software, to find (a) \(B(7 ; 18,0.45)\); (b) \(b(7 ; 18,0.45)\); (c) \(B(8 ; 11,0.95)\); (d) \(b(8 ; 11,0.95)\); (e) \(\sum_{k=4}^{11} b(k ; 11,0.35)\); (f) \(\sum_{k=2}^{4} b(k ;...
-
Which conditions for the binomial distribution, if any, fail to hold in the following situations? (a) The number of persons having a cold at a family reunion attended by 30 persons. (b) Among 8...
Study smarter with the SolutionInn App