Create student db and perform delete operation, Database Management System

Assignment Help:

Create Student DB and perform delete operation?

STUDENT (name, student#, class, major)
COURSE (course name, course#, credit hours, department)
SECTION (section identifier, course#, semester, year, instructor)
GRADE_REPORT (student#, section identifier, grade)
PREREQUISITE (course#, presequisite#)

Delete the record for the student whose name is ‘Smith' and whose student number is 17.

Query

DELETE FROM STUDENT WHERE NAME = ‘Smith' AND STUDENT# = 17

Related Discussions:- Create student db and perform delete operation

Creating views with replace option, Creating views with Replace option : Th...

Creating views with Replace option : This option is used to alter the definition of the view without recreating and dropping it or regranting object privileges previously granted o

List out user authorization to modify the database schema, List out various...

List out various user authorization to modify the database schema. a) Index authorization b) Resource authorization c) Alteration authorization d) Drop authorizat

Discuss along with examples about several types of er model, Discuss along ...

Discuss along with examples about several types of attributes present in the ER model? Types of Attributes are: • SIMPLE attributes are attributes which are drawn from the ato

State the technique of converting the state diagram to code, The technique ...

The technique of converting the state diagram to code a) Identify all major control paths. Start from initial state; choose a path across the diagram that corresponds to normal

What is sql, What is SQL, and why is it important? SQL stands for Struc...

What is SQL, and why is it important? SQL stands for Structured Query Language, and is the most significant data processing language in use today. It is not a complete programm

Functional dependency in entities, FDs in Entities : Student entity : ...

FDs in Entities : Student entity : Enrolment number → Student name, Address Course Entity :

Task partitioning, Task Partitioning, Sequencing and Project Planning T...

Task Partitioning, Sequencing and Project Planning The tasks required for the service might be broadly partitioned into: 0. Set up database tables and account file

State in brief about object design, Give the Introduction of OBJECT DESIGN ...

Give the Introduction of OBJECT DESIGN Strategies which are selected during system design are carried out in object-oriented design. In this procedure, objects which are identi

Having clause-data manipulation language, Having clause This clause...

Having clause This clause is used for producing conditions on grouped information. Example: Find maximum salary and department number of those departments where maxim

What are advantages of object models, What are advantages of object models?...

What are advantages of object models? Object models are efficient for communicating with the application experts and reaching a consensus about the significant aspects of the p

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages