Reference no: EM13913265
Create the following tables: student (sid, sname, sex, age, year, gpa) dept (dname, numphds) prof (pname, dname) course (dname, cno, cname) major (dname, sid) section (dname, cno, sectno, pname) enroll (sid, dname, cno, sectno, grade) Queries-
1. Print the names of professors who work in departments that have fewer than 50 PhD students.
2. Print the names of the students with the lowest GPA.
3. For each Computer Sciences class, print the class number, section number, and the average gpa of the students enrolled in the class.
4. Print the names and section numbers of all classes with more than six students enrolled in them.
5. Print the name(s) and sid(s) of the student(s) enrolled in the most classes.
6. Print the names of departments that have one or more majors who are under 18 years old.
7. Print the names and majors of students who are taking one of the College Geometry courses.
8. For those departments that have no major taking a College Geometry course print the department name and the number of PhD students in the department.
9. Print the names of students who are taking both a Computer Sciences course and a Mathematics course.
10. Print the age difference between the oldest and the youngest Computer sciences major.
11. For each department that has one or more majors with a GPA under 1.0, print the name of the department and the average GPA of its majors. 12. Print the ids, names and GPAs of the students who are currently taking all the Civil Engineering courses.
|
It employs regular-dividend-plus-extras policy
: In 2011 the Keenan Company paid dividends totaling $3,960,000 on net income of $18.8 million. Note that 2011 was a normal year and for the past 10 years, earnings have grown at a constant rate of 8%. It continues the 2011 dividend payout ratio. It em..
|
|
Describe production characteristics of three products
: Describe the characteristics of products which would suggest it would be better to use ABC as an indirect cost allocation method over a traditional method such as direct labor hours.
|
|
Present value of the debt
: In transaction, determine the present value of the debt.
|
|
What makes zipcar an attractive employer for which to work
: What makes Zipcar an attractive employer for which to work? What do those doing the actual hiring at Zipcar feel are important characteristics to find in potential employees
|
|
Create a tables student that print names of students
: Create the following tables: student (sid, sname, sex, age, year, gpa) that Print the names of the students with the lowest GPA.
|
|
The following information is from abc company
: The following information is from ABC Company's general ledger: Beginning and ending inventories, respectively, for raw materials were $8,000 and $10,000 and for work in process were $20,000 and $22,000.
|
|
Discounted payback period for the investment project
: What is the discounted payback period for the investment project that has the following cash flows, if the discount rate is 14 percent?
|
|
Depreciation on the equipment to produce the new board
: Rolston Music Company is considering the sale of a new sound board used in recording studios. The new board would sell for $25,800, and the company expects to sell 1,430 per year. The company currently sells 1,930 units of its existing model per year..
|
|
The following cost behavior patterns describe anticipated
: The following cost behavior patterns describe anticipated manufacturing costs for 2013: raw material, $7/unit; direct labor, $10/unit; and manufacturing overhead, $240,000 + $8/unit.
|