Create a table student with attributes student name, Database Management System

Assignment Help:

Question 1 Create a table student with attributes student name, roll number, total marks and percentage. Do the following operations

Insert details in to the table
Update the details of the student named ‘JOHN'
Delete details of the student ‘Mary'
Display the details of students having more than 80%

Question 2 Write the following Queries using functions

Write a query to display the sub string for the word 'oracle' from its position 2 to 3
Write a query to change the ‘or' to ‘ab' in the word 'corporation' using translate function
Write a query to maintain the first letter as caps using initcap function
Write a query to display all characters is in caps using upper function
Write a query to display ‘smudde' after leaving 5 blank places using lpad function

Related Discussions:- Create a table student with attributes student name

Draw the dependency diagram for the relation, Consider the subsequent relat...

Consider the subsequent relation Professor (Pfcode, dept, head, time) It is assumed that (i) A professor can work in much more than one

Define the immediate update, Define the Immediate Update The immediate...

Define the Immediate Update The immediate update methods may apply changes to the database on disk before the transaction arrives a successful conclusion. Though, these change

Physical database design issues, Physical Database Design Issues The da...

Physical Database Design Issues The database design includes the process of logical design with the use of E-R diagram, normalisation, etc., followed by the physical design.

Create student db and execute insert query, Create Student DB and execute I...

Create Student DB and execute Insert query? STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, course

Datamanagement, What is Information System?

What is Information System?

What is a transaction, What is a Transaction? A transaction is an even...

What is a Transaction? A transaction is an event which happens on the database. Generally a transaction reads a value from the database or writes a value to the database. If y

Design an entity relation model, Funky Festivals Specification Funky Fe...

Funky Festivals Specification Funky Festivals organise music festivals which take place at various venues throughout the UK. A venue needs to be booked before a Festival can t

MYSQL, write an SQL statement to create the database in MYSQL server

write an SQL statement to create the database in MYSQL server

Explain displaying an er schema as an er diagram, Explain the conventions f...

Explain the conventions for displaying an ER schema as an ER diagram? An E-R Diagram scheme might describe certain constraints to that the contents of a database must conform.

Horizontal Fragmentation, I want to fragment existing table using java code...

I want to fragment existing table using java code... help me..!!

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages