After reviewing the various ERDS, Trinity University has decided on the following tables and columns. Primary...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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) 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)
Expert Answer:
Answer rating: 100% (QA)
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 the full answer
Related Book For
Posted Date:
Students also viewed these 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...
-
The following balance sheets were prepared for Pam Corporation and Slest Company on January 1, 20X2, just before they entered into a business combination: Pam acquired all of Slest Companys assets...
-
In 2011, the Cuban government enacted an 8 percent tax on the purchase of real estate, with the tax split by the buyer and seller [Cave, 2011]. Is it likely that the tax will actually be split 50 50...
-
What is the most probable value of r, in the ground state of hydrogen? (The answer is not zero!)
-
An engineering student wants to satisfy her curiosity about the compressibility of air in motion. She has set up a converging nozzle in which air discharges into the atmosphere. Figure P11.39 shows...
-
Southeastern Airliness daily flight from Atlanta to Charlotte uses a Boeing 737, with all-coach seating for 120 people. In the past, the airline has period every seat at $140 for the one-way flight....
-
In the "Stakeholder Analysis in Projects" article this week, the authors Jepsen and Eskerod (2008) found that the "guidelines provided in current literature are far too general to be useful for...
-
12 Mitchell's Specialties sells high-end furniture (dressers, chairs, sofas, and tables). The company has been in business for several years. Based on its experience, management projects next year's...
-
How do you advocate for a supportive and inclusive school culture?
-
What are the factors that control the performance of a website?
-
List the factors that determine website flow.
-
When designing the interactive services of a website what steps should the designer take to provide a quality service to customers?
-
What types of product are most amenable to changes to the core and extended product?
-
Discuss whether you consider that all products on sale in the high street can be sold as easily via the Internet.
-
Provide a construct that demonstrates the use of distributed computing. Your construct should involve the client/server network communications model.
-
Consider the advantages and disadvantages of extending property rights so that everyone would have the right to prevent people imposing any costs on them whatsoever (or charging them to do so).
-
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...
-
Apple stock is selling for \($120\) per share. Call options with a \($117\) exercise price are priced at \($12.\) What is the intrinsic value of the option, and what is the time value?
-
Ibrahim bought 200 shares of a stock trading in the Abu Dhabi Securities Exchange at AED 12 (United Arab Emirates dirham) per share. Over time, the price of the stock increased to AED 18 per share....
-
Twitter is trading at \($34.50.\) Call options with a strike price of \($35\) are priced at \($2.30\) . What is the intrinsic value of the option, and what is the time value?
Study smarter with the SolutionInn App