What classes are necessary to obtain a specific degree

Assignment Help Database Management System

Reference no: EM13763714

Weekly tasks or assignments (Individual or Group Projects) will be due by Monday and late submissions will be assigned a late penalty in accordance with the late penalty policy found in the syllabus. NOTE: All submission posting times are based on midnight Central Time.
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.

Reference no: EM13763714

Questions Cloud

Explain the efforts of law enforcement agencies : Use the Internet to research articles on the efforts of law enforcement agencies to combat digital crimes and digital terrorism, as well as the roles of such agencies in the future of the combat in question.

Find out value of information : Firms realize that in order to make money, they have to invest money. This can be attributed to the information that the firm relies on.

Active directory user object creation tool : Determine at least two (2) Windows Server 2012 Active Directory user creation scenarios and specify one (1) Active Directory user object creation tool that you believe is the most efficient for each scenario.

Justification for why the bill should be approved or not : You are the criminologist advisor to a member of the state legislature. The legislature will soon vote on a bill that, if it passes, would double the maximum prison term for anyone convicted of armed robbery. Justification for why the bill should b..

What classes are necessary to obtain a specific degree : 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

Describe a key conflict in the play tragedy : Describe a key conflict in the play and how it corresponds to a character's development.

Problems based on genetics : Describe how abnormal chromatin remodeling is a result of a genetic mutation in the gene, ATRX.

Identify the state of the domestic violence problem : This assignment measures your knowledge of comparative domestic violence (DV) between present-day American society to that of four other cultures. Identify the state of the domestic violence problem in American society

Management support systems : Review the main management support systems discussed of the textbook. Next, select one (1) such system, and describe its key components, capabilities, and the overall manner in which an organization could benefit from it

User Account

All Pages