VTU DBMS Notes Doc

I am studying at Visvesvaraya Technological University Karnataka. Here I want to know the Data Base Management System (DBMS) of the University. Would you like to give me the notes of its data base?
Visvesvaraya Technological University

Here I am providing you notes of Computer Science and Engineering 5th Semester DBMS Laboratory
All programs have been worked under MySql.

1. Consider the Insurance database given below. The primary keys are
underlined and the data types are specified:
PERSON (driver – id #: String, name: string, address: string)
CAR (regno: string, model: string, year: int)
ACCIDENT (report-number: int, accd-date: date, location: string)
OWNS (driver-id #:string, Regno:string)
PARTICIPATED (driver-id: string, Regno:string, report-number:int,
damage amount:int)
(i) Create the above tables by properly specifying the primary keys and
The foreign keys.
(ii) Enter at least five tuples for each relation.
(iii) Demonstrate how you
a. Update the damage amount to 25000 for the car with a specific
Regno in the ACCIDENT table with report number 12.
b. Add a new accident to the database.
(iv) Find the total number of people who owned cars that were involved in accidents in 2008.
(v) Find the number of accidents in which cars belonging to a specific model were involved.
(vi) Generate suitable reports.
Rest of the notes I am providing you the link

tvvikram.hubpages.com/hub/vtudbmslabnotes

__________________
Answered By StudyChaCha Member

sir,i want 4th sem mechanical notes.......if you give me link i can get it.....

Visvesvaraya Technological University Karnataka was established on April 1, 1998. it is a collegiate public state university in Karnataka State, India.

As you required for the VTU DBMS Notes,here is it

1.0 Introduction and brief history to Database
1.1 Characteristics of database
1.2 Difference between File System & DBMS.
1.3 Advantages of DBMS
1.4 Functions of DBMS
1.5 Role of Database Administrator
1.6 Simplified Database System Environment
1.7 Example of a Database
1.8 Architecture of DBMS
1.9 Data Independence
1.10 Types of database applications
1.11 Data Models
1.12 The database system environment
1.13 Centralized and Client-Server DBMS Architectures

VTU DBMS Notes










Rest is attached below please have a look on that it is free for you to download

Address
Visvesvaraya Technological University
Jnanasangama Machhe, Khanapur Road, Khanapur Road, Machha Industrial Area, Machhe, Belgaum, Karnataka 590014 ‎
0831 240 5458 ‎

Attached Files Available for Download

VTU DBMS Notes.pdf (784.7 KB, 135 views)

__________________
Answered By StudyChaCha Member