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?
-
A 1-km-long, 10-Mbps CSMA/CD LAN (not 802.3) has a propagation speed of 200 m/sec. Repeaters are not allowed in this system. Data frames are 256 bits long, including 32 bits of header, checksum, and...
-
Prove the second absorption law from Table 1 by showing that if A and B are sets, then A (A B) = A.
-
A \(45^{\circ}\) off-axis rail shear test specimen of an orthotropic lamina is shown in Figure 10.38. Attached to the specimen are three strain gages that measure the normal strains...
-
During company estimates that total factory overhead costs will be $750,000 for the year. Direct labor hours are estimated to be 300,000. For Darling company, (a) Determine the predetermined factory...
-
Consider a rectangular wing mounted in a low - speed subsonic wind tunnel. The wing model completely spans the test section so that the flow sees essentially an infinite wing. If the wing has an NACA...
-
Use polygons and lines to create a graphics image that looks like a fireworks display. Write an application that extends JPanel and displays the fireworks. Save the file as JFireworksPanel.java.
-
Re-read pages 49-51 on the concept of a "Self-Fulfilling Prophecy". Write one page about what this concept means, and how it could apply to you at your job or in your career. Minimum of one source...
-
A 5 kg mass hangs from a rope which runs up over a pulley and down to a 3 kg mass. Everything is placed in an elevator which accelerates upward at 3 m / s 2 . What is the acceleration of the 5 kg...
-
Simplify the expression. 2 x-25 10x+25
-
Solve the system of equations by using the elimination method. (If the system is dependent, enter a general solution in terms of c. If there is no solution, enter NO SOLUTION.) 4x + y 8x + 2y = 5 = 10
-
Describe the difference between a mediator and an arbitrator, then provide an example of each.
-
Explain What are your view on working with labor union. Explain in detail.
-
For a 4 KVA, 200/400 V, 50 Hz, 1 - phase transformer, calculate the efficiency, voltage at the secondary terminals and primary input current when supplying a full - load secondary current at 0.8...
-
What are three disadvantages of using the direct write-off method?
-
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...
-
What kinds of relationships would qualify for a protective order in an inclusive state?
-
What approaches have states traditionally taken with respect to same sex couples?
-
What kinds of abusive behavior are covered by most abuse prevention laws?
Study smarter with the SolutionInn App