Question: After reviewing the various ERDS, Trinity University has decided on the following tables and columns. Primary key fields are highlighted in red. Base Tables:

After reviewing the various ERDS, Trinity University has decided on the following

After reviewing the various ERDS, Trinity University has decided on the following tables and columns. Primary key fields are highlighted in red. Base Tables: DEPARTMENT DeptID DeptName (NN) PROFESSOR ProfiD ProfSpecialty ProfRank ProfLName (NN) ProfFName (NN) Profinitial ProfEmail COURSE CourselD CourseTitle (NN) STUDENT StudentID StudentLName (NN) StudentFName (NN) Studentinitial StudentEmail CourseDescription CourseCredits Tables with Foreign Keys: DEPTCHAIR ProfessorID DeptID STUDENTDEPT StudentID DeptID ADVISOR ProfessorID StudentID COURSEDEPT CourselD DeptID ww. www w CLASS ClassID CourselD ProfiD ClassSection ClassDays ClassTime ENROLL Student ID CourselD ClassID EnrollmentDate (NN) Grade (NN)

Step by Step Solution

★★★★★

3.47 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

My answer is in the form below SQL code to drop and create the above tables DROP TABLE IF EXISTS ENROLL DROP TABLE IF EXISTS CLASS DROP TABLE IF EXISTS DEPTCHAIR DROP TABLE IF EXISTS STUDENTDEPT DROP ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

After reviewing the various technologies that are available for use in criminal investigations, which technology would you recommend to your colleagues for use during criminal investigations? Why?....

University administrators have collected the following information concerning student grade point average and the school of the students major. Determine if there is any association between GPA and...

In a class on probability, a statistics professor flips two balanced coins. Both fall to the floor and roll under his desk. A student in the first row informs the professor that he can see both...

A bond has $ 15000 face value and its coupon rate is 14.5 % (APR). The YTM of bonds with similar risks is 15.4%. Coupon is paid on an annual basis at the end of each years. The maturity of this bond...

Bob and Thelma Mellankamp have come to realize that the current problems with their inventory control, customer ordering, and management reporting systems are seriously affecting Hoosier Burgers...

Variable price and usage variances and fixed manufacturing overhead cost variances Kemp Tables, Inc. (KTI), makes picnic tables of 2 3 4 planks of treated pine. It sells the tables to large retail...

Jones, CPA, audits a number of public-companies. During the past year, some deficiencies with respect to audits conducted for two of Joness clients in the software industry (SoftWare and...

4. How else might Walter have gone about defining work tasks, creating the schedule, and assigning responsibility? Walter has just been assigned to manage a projecthis first experience as a project...

What do you think of Walters approach to balancing the workload among the team members? Walter has just been assigned to manage a projecthis first experience as a project manager. The project...

The bank statement for Rudys Painting Company had an ending balance as of March 31 of $42,765.88. Also listed on the statement was a service charge for $27.50. Check 1305 that Rudy wrote to pay for...

fou find the following corporate bond quotes. To calculate the number of years until maturity, assume that it is currently January 15 , 2022. The bonds have a par value of $2,000 and semiannual...

What are the specific activities that could make up your project? pleaselist the activities with their information on immediate predecessor andcompletion time, in both a table, and PERT chart.

from your own experience, describe a situation in which you provided a double message. Did you intentionally provide it?

Free vibration of two rotor system The flywheel of an engine driving a dynamo has mass of 200kg and has a radius of gyration of 30cm. The shaft at the flywheel end has as an effective length of 25cm...

All-A-Buzz makes three products from a joint production process using honey. Joint cost for the process for the year is $246,400. Per Unit Incremental Units of Selling Price Processing Final Sales...

You are the dealer in one of the reputable banks and one of your roles is related to trading and monitoring of changes in the derivative markets. You are interested in one stock for Bally...

Kevin Nguyen works for ABCO Corporation at a salary of $700 per week. He is paid every two weeks. The following is deducted from his bi-weekly pay: income tax $185, CPP $60, and EI premiums of $25....

What are the key dimensions of critical thinking 2. Watch the NBC Learn video on Diet Scams. What types of claims are made in this video Are they valid Elaborate on your responses. Discuss this video...

Vaga Optics produces medical lasers for use in hospitals. The accounts and their balances appear in the ledger of Vaga Optics on December 31 of the current year as follows: Preferred 2% Stock, $120...

Warehouse System Inc. recognized service revenue of $960,000 on its financial statements in 2011. Assume, however, that the tax code requires this amount to be recognized for tax purposes in 2012....

Altria Group, Inc., has a note dedicated to describing contingent liabilities in its recent financial statements. This note includes extensive descriptions of multiple contingent liabilities . Use...

2. In which brain areas do new neurons form in adults?

5. If all cells in an amphibians tectum produced the same amount of TOPDV, what would be the effect on the attachment of axons?

3. Record brain activity during behavior. We might record changes in brain activity during fighting, sleeping, finding food, solving a problem, or any other behavior.