Reference no: EM13948208
Using SQL 2005, Download, unzip, and attach the sample database ITD640_A from the link below. The sample database represents an educational institution with students and different schools. Each student goes to just one school. The students have various roles in different assignments and may work on more than one assignment at a time.
The following are the tables and data in the ITD640_A database:
Using the sample database, write the scripts in a file called ITD640_P3.SQL to create the following views. Include a USES clause at the top of the script file to use the ITD640_A database. Also include code that checks if the view already exists. If it does, it should be dropped and recreated.
1. Create a view named v_worker showing the student number, assignment number, and start date where the role is "worker."
2. Create a view called v_no_points with all the columns of the assignment table except the points column.
3. Create a view called v_count that shows the number of students working on each assignment. The view should have columns for the assignment number and the count.
Attachment:- 1_u3ips.zip
|
Effect on the organizational structure
: Assignment: Kudler Fine Foods is in the process of developing a new frequent shopper program. Details of this program are described in the Service Request SR-kf-013 and on the Sales & Marketing page of the Kudler Fine Foods intranet website.
|
|
Discus the drummer-buffer-rope concept using the young data
: Assume that a 1.5-day buffer inventory is needed to deal with any production interruptions. Describe the drummer-buffer-rope concept using the Young data to illustrate the process.
|
|
Unappropriated retained earnings
: Based on the above, use schedule M-2 of form 1120 to determine swan's unappropriated retained earnings balance as of December 31, 2012.
|
|
Receive one new payment-record one new expense
: Add one new customer. Take a screenshot of the result. Add one new vendor. Take a screenshot of the result.
|
|
Create a view named v_worker showing the student number
: Create a view called v_no_points with all the columns of the assignment table except the points column.
|
|
What is the significance of using the aggregated data
: What were the major reasons the researchers chose this method to study this case rather than another study design? What is the significance of using the aggregated data from the three major organizations (i.e., American Heart Association, Centers ..
|
|
Determine the overhead rate for each activity
: Determine the overhead rate for each activity.
|
|
Cell phone design process
: You work for Motorola in the global cell phone group. You have been made operations/project manager for the design of a new cell phone model. Your supervisors have already scoped the project so you have a list showing the work breakdown structure ..
|
|
Compute the maximum and minimum loads
: A 15.2 mm (0.60 in.) diameter cylindrical rod fabricated from a 2014-T6 aluminum alloy (Figure 8.34) is subjected to a repeated tension- compression load cycling along its axis. Compute the maximum and minimum loads that will be applied to yield a..
|