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

Basic concept of data base management system, INTRODUCTION Databases a...

INTRODUCTION Databases and database systems have become an essential part of our daily life. We encounter many activities that involve some interaction with a database almost

Adding redundant associations for efficient access, Adding Redundant Associ...

Adding Redundant Associations for Efficient Access Redundant associations do not add any type of information, therefore during design we should actually examine structure of o

Aggregation, Aggregation : One limitation of the E-R diagram is that they d...

Aggregation : One limitation of the E-R diagram is that they do not permit representation of relationships between relationships. In such a case the relationship along with its ent

Attribute, composite attribute

composite attribute

Which is a valid sql type, Which is a valid SQL type? A valid SQL Shoul...

Which is a valid SQL type? A valid SQL Should be in CHARACTER it is should be NUMERIC and FLOAT.

Apriori algorithm-find all frequent large itemsets, Your friend owns a comp...

Your friend owns a computer store in Yuen Long, selling Desktop and Notebook PCs and other computer peripherals. Having been rather successful with his business there, he decided t

Which data manipulation command combines the records, Which data manipulati...

Which data manipulation command combines the records from one or more tables ? JOIN data manipulation command combines the records from one or more tables.

Develop motel point of sale software, Project Description: I need a poin...

Project Description: I need a point of sale for motels. It needs to run on windows and requires being network able so that we can have more than one computer using it at once.

Create a query to produce single output-er model, This assignment concerns ...

This assignment concerns the Research database. The database ER model is shown above, where attributes are omitted for clarity. The relational model for the database is: Departm

Draw an e-r diagram and convert it to a relational schema, In an organisati...

In an organisation various projects are undertaken. Each projects can employ one or more employees. Every employee can work on one or more projects. Each project is undertaken on

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages