Scribd Logo
Upload

Welcome to Scribd!

  • 1K views

    SQL Server Question Paper - 1

    Uploaded by

    api-3766129
    The document provides instructions for creating an E/R model and database for a School Management system, including defining the tables for Teachers, Subjects, Students, and MarkSheet, and inserting sample records. It also includes short definitions for key database concepts like DBMS, RDBMS, tables, data types, and constraints. Practical instructions are given to design the E/R model, create the database and tables, insert records, and check data integrity for the School Management system.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd

    SQL Server Question Paper - 1

    Uploaded by

    api-3766129
    1K views3 pages
    The document provides instructions for creating an E/R model and database for a School Management system, including defining the tables for Teachers, Subjects, Students, and MarkSheet, and inserting sample records. It also includes short definitions for key database concepts like DBMS, RDBMS, tables, data types, and constraints. Practical instructions are given to design the E/R model, create the database and tables, insert records, and check data integrity for the School Management system.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides instructions for creating an E/R model and database for a School Management system, including defining the tables for Teachers, Subjects, Students, and MarkSheet, and inserting sample records. It also includes short definitions for key database concepts like DBMS, RDBMS, tables, data types, and constraints. Practical instructions are given to design the E/R model, create the database and tables, insert records, and check data integrity for the School Management system.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    1K views3 pages

    SQL Server Question Paper - 1

    Uploaded by

    api-3766129
    The document provides instructions for creating an E/R model and database for a School Management system, including defining the tables for Teachers, Subjects, Students, and MarkSheet, and inserting sample records. It also includes short definitions for key database concepts like DBMS, RDBMS, tables, data types, and constraints. Practical instructions are given to design the E/R model, create the database and tables, insert records, and check data integrity for the School Management system.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    You are on page 1of 3

    Write short notes on following

    1. DBMS
    2. How many types of DBMS
    3. RDBMS
    4. Database
    5. E/R Model
    6. Tables, Columns, Rows, Data Type, Constraints

    Practical
    1. Prepare E/R Model for SchoolManagement based on the given tables in 3rd Point
    2. Create SchoolManagement Database
    3. Create Following Tables
    a. Teachers
    b. Subjects
    c. Students
    d. MarkSheet
    4. Insert the records and also check data integrity

    Answers:-
    1)DBMS:-DBMS stands for Data Base Management System .
    This is a software program which handles most aspects of the data management
    Includes storing data,retrieving data, running queries on data and providing
    Security etc…
    The DBMS manages incoming data, organizes it
    Ex:-Sql server,Microsoft Access,Oracle,Mysql,Faxpro,Dbase
    2)There are three types of DBMS
    a)Hierarchical
    b)Network
    c)Relational.

    3)RDMS:-RDBMS stands for Relational Data Base Management System.


    This is a soft ware program which manages data.This organizes data
    In the form of tables.
    Ex:-Sql server,Oracle,Sybase etc..
    4)Database:-Collection of structured data is called database.This is typically
    Made up of many linked tables of Rows and Columns.
    5)E/R stands for Entity Relation ship.Entity is an object of some sort.
    A relation ship is a connection between two or more entity sets.
    The entity relation ship model enables us to draw diagrams of database
    Designs.
    6)Table:- Table is a database object that contains all the data in database.
    Collection of columns is called table.In tables data is organized in
    A row and column format.
    Columns are called attributes. Rows are called tuples.
    Data type:-The data type specifies what kind of information such as numeric,
    integer etc...
    And how much space that information takes up in particular columns.
    Ex:-Int,char,varchar,money,datetime
    Constraints:- Constraints is a property assigned to a column in a table that
    Prevents certain types of inconsistent data values from being placed in columns.
    These are used to enforce the data integrity.

    Create database schoolmanagement

    Create table Teachers


    (
    T_id int primary key,
    T_name varchar(20),
    Deptno int not null,
    Deptname varchar(20),
    Sal money
    )

    Create table Subjects


    (
    Sub_id int,
    Sub_name varchar(20)
    )

    Create table students


    (
    St_id int unique,
    St_name varchar(20) ,
    Class varchar(10)
    )
    Create table Markssheet
    (
    St_id int unique,
    St_name varchar(20),
    Marks1 int,
    Marks2 int,
    marks3 int,
    Total int,
    S_avg int
    )
    Insert into Markssheet(St_id,St_name,Marks1,Marks2,marks3)
    values(01,'Druva',100,90,89)
    Insert into Markssheet(St_id,St_name,Marks1,Marks2,marks3)
    values(02,'Nipun',100,87,89)
    select * from Markssheet
    insert into students
    values(1,'Druva','6th')
    insert into students
    values(2,'Nipun','9th')
    insert into subjects
    values(100,'Maths')
    insert into subjects
    values(101,'Physics')
    insert into subjects
    values(102,'Chemistry')
    insert into subjects
    values(103,'English')
    select * from subjects

    insert into teachers


    values(01,'Padma',10,'Maths',20000)

    insert into teachers


    values(02,'Hema',20,'Chemistry',30000)

    insert into teachers


    values(03,'Ramu',30,'Physics',40000)

    insert into teachers


    values(04,'Rama',40,'English',20000)

    select * from teachers


    select * from students
    select * from subjects
    select * from markssheet

    You might also like