(Answered) Using your week 1 ip as a starting point extend the design

Engineering

Using your Week 1 IP as a starting point, extend the design to accommodate degree programs. The new design should incorporate the following functionalities:

A degree has a name and description.

What degree is the student working towards? A student can only work on one degree at a time.

What classes are necessary to obtain a specific degree?

Provide the DDL script to add the tables for the new design changes. Include an updated diagram that shows all the tables in the system.

Write the DML script to insert 3 test records in each of the tables in the system. This data will be necessary to write the queries in the next assignment.

Copy and paste the work into your Key Assignment document and include screen shots of each step, describe what you did for each step and paste in the actual SQL text used to perform each step. Upload your document to the Submitted Tasks section.

View complete question

Computer Engineering, Engineering

Category:- Computer Engineering
Reference No.:- M91763560
Price:- $30

Verified Expert

Priced at $60 Now at $30, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Computer Engineering

Jeff decides to start saving some money from this upcoming

Jeff decides to start saving some money from this upcoming month onwards. He decides to save only $500 at first, but each month he will increase the amount invested by $100. He will do it for 60 months (including the fir ...

Requirementsthis week you will write single page web

Requirements This week you will write single page web application that will receive incoming POST and GET requests. If it is a POST request it should say at the top of the page, in an H1 tag "POST Request Received". If a ...

Select three interfaces and consider how the teamwork

select three interfaces, and consider how the teamwork application could be redesigned for each of these types. Use your imagination. How about using a tangible interface or even a drone to help remote students collabora ...

Roberto is the network administrator for an international

Roberto is the network administrator for an international law firm with offices and customers in North America, South America, Africa, and the Middle East. The lawyers frequently contact each other via e-mail, use the In ...

Analytic reportpurpose the purpose of this task is to

Analytic Report: Purpose: The purpose of this task is to provide students with practical experience in working in teams to write a Data Analytical report to provide useful insights, pattern and trends in the chosen/given ...

Planks plants had net income of 4000 on sales of 70000 last

Plank's Plants had net income of $4,000 on sales of $70,000 last year. The firm paid a dividend of $1,480. Total assets were $200,000, of which $80,000 was financed by debt. a. What is the firm's sustainable growth rate? ...

Assignmentnbspon information systems audit and

Assignment on Information Systems audit and controls Assignment purpose: Elaborate on the different types of control that are applied in a hospital (Preventive, detective and corrective control). Evaluate the logical an ...

Is there any difference in terms of the information that

Is there any difference in terms of the information that could be provided to the decision maker by an IS that was created using HSM and an IS that was created using SSM?

Question show me how write a program that prompts the user

Question Show me how Write a program that prompts the user for a student grade average (e.g. 86.7) and outputs what the letter grade should be. Ensure that your program notifies the user if he/she enters a non-valid aver ...

Should we be renegotiating nafta yes or no if it is

Should we be renegotiating NAFTA? yes or no? If it is renegotiated, should it be replaced? What reasons would make it better in your point of view? What is the best argument you can make why NAFTA should or should not be ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Computer Engineering Expert