Delete a database table

Assignment Help Basic Computer Science
Reference no: EM131240121

Create tables: Faculty, Course, Student, Qualified and Registration.11 ed (fig 7-16) or (fig 7-25) 12 ed.

1. Insert data into those tables.

2. Write queries for a, b and c.

Write and run following SQL queries on the tables you created above:

List the course names and all sections that are available to students.

List the total number of students registered in the school.

List the names of the students who are enrolled in two or more courses.

List the Faculty names and courses that are most popular for students.

Create a trigger that will display warning message, "please consult with DBA first before delete a database table", when user attempting to delete it

STUDENT(StudentID, StudentName)

StudentID

StudentName

38214

Letersky

54907

Altvater

66324

Aiken

70542

Marra

QUALIFIED (FacultyID  ,CourseID, DateQualified)

FacultyID

Course ID

Date Qualified

2143

ISM 3112

9/1988

2143

ISM 3113

9/1988

3467

ISM 4212

9/1995

3467

ISM 4390

9/1996

4796

ISM 3113

9/1996

4756

ISM 3112

9/1991

FACULTY (FacultyID , FacultyName

FacultyID

Faculty Name

2143

Birkin

3467

Berndt

4756

Collins

SECTION(Section No, Semester,CourseID)

SectionNo

Semester

CourseID

2712

I-2008

ISM 3113

2713

I-2008

ISM 3113

2714

I-2008

ISM 4212

2715

I-2008

ISM 4930

COURSE ( CourseID,Course Name)

CourseID

CourseName

ISM3113

Syst Analysis

ISM 3112

Syst Design

ISM 4212

Database

ISM 4930

Networking

REGISTRATION (StudentID ,  Section NoSemester)

StudentID

SectionNo

Semester

38214

2714

I-2008

54907

2714

I-2008

54907

2715

I-2008

66324

2713

I-2008

Reference no: EM131240121

Questions Cloud

Discuss a company that does an effective job of utilizing : Construct a 2-3 page paper, based on the four characteristics of a product with potential for sustainable competitive advantage and based on the research you conducted; identify and discuss a company that does an effective job of utilizing these r..
How many armbands need to be grabbedsome of the players deci : How many armbands need to be grabbed in order to assure that one of the teams has at least seven players?
Bound on the number of times heap : (a) Argue that the algorithm above (1) outputs numbers in increasing order, (2) doesnot output any number twice, (3) only outputs humble numbers, and (4) outputs all of thefirst n humble numbers. (b) Derive an exact (i.e., no O-notation) bound on ..
What if the three flavors have to be different : Four teams are attending a local Ultimate Frisbee meet. If each team plays each other team exactly once, how many games are played?
Delete a database table : Create a trigger that will display warning message, "please consult with DBA first before delete a database table", when user attempting to delete it
Are the 4ps no longer relevant : Are the 4Ps no longer relevant? If they are, are they only relevant to certain industries, channels, or products? Which ones? Are the 4Cs able to replace the 4Ps in every business environment?
Keys to designing a successful data communications network : What are the keys to designing a successful data communications network? -  How does the traditional approach to network design differ from the building-block approach?
Prepare all general journal entries for the two bonds issued : Prepare all general journal entries for the 2 bonds issued and any interest accruals and payments for the fiscal year 2016. What is the carrying amount on the December 31, 2016 Balance Sheet for 4A. and 4B?
Describe the key parts of the technology design step : Describe the key parts of the technology design step. - How can a network design tool help in network design? - On what should the design plan be based?

Reviews

Write a Review

Basic Computer Science Questions & Answers

  The contenders are tortoise and hare

The contenders are Tortoise and Hare, and they begin race as investors at "tile 1" of 70 tiles The finish line is at 70 the tile. With each tick of the clock

  Build an entity relationship model

Build an entity relationship model

  Different it systems

Identify five different IT systems that have affected business in the past few years. For each system, briefly note the following

  Stakeholders of customer support systems

Charlie and Suzanne have been given a new assignment: PPI has decided to build a new website. All information about the company and its products will be available via the website.

  Create a plot of a cubic spline fit

Create a plot of a cubic spline fit of following data with natural end conditions: x 0 100 200 400f(x) 0 0.82436 1.00000 0.73576. compare the plot with the following equation which was used to create data.

  Write the declarations needed for this implementation

A priority queue is implemented as a sequential array-based list. The highest-priority element is in the first array position, the second-highest priority element is in the second array position, and so on.

  Prompt method to get the investment amount

Modify the the JavaScript code so it provides for the option buttons. When the user click the Yearly Interst button, the application should compound the interest yearly, when the user clicks the Monthly Interest button, the application should comp..

  Maximum number of employees

What is the maximum number of employees that a company with a health plan can have and not be subject to the COBRA rules?

  Create a database schema that supports the companys business

Create a database schema that supports the companys business and processes - Explain and support the database schema with relevant arguments that support the rationale for the structure.

  How important specific programming features are of each type

how important specific programming features are for each type of game.

  Waveguide for mono-mode transmission

Design a rectangular air-filled waveguide for mono-mode transmission of the frequency band 3.6GHz~4.6GHz.

  What are the barriers for elevit

What are the barriers for ‘Elevit'?(please google the product first)? How does ‘Elevit' do toremove barriers in order tomotivate 25 to 35year old pregnancy planners to start taking ‘Elevit' before they become pregnant (and to continue taking supple..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd