Database Management System Laboratory With Mini Project
Database Management System Laboratory With Mini Project

Module - 1

Design, develop, and implement the specified queries for the following problems using Oracle, MySQL, MS SQL Server, or any other DBMS under LINUX/Windows environment.
 Create Schema and insert at least 5 records for each table. Add appropriate database
constraints.

Aim: Demonstrating creation of tables, applying the view concepts on the tables.
ProgramConsider the following schema for a Library Database:
BOOK(Book_id, Title, Publisher_Name, Pub_Year)
BOOK_AUTHORS(Book_id, Author_Name)
PUBLISHER(Name, Address, Phone)
BOOK_COPIES(Book_id, Programme_id, No-of_Copies)
BOOK_LENDING(Book_id, Programme_id, Card_No, Date_Out, Due_Date)
LIBRARY_PROGRAMME(Programme_id, Programme_Name, Address)
Write SQL queries to
1. Retrieve details of all books in the library – id, title, name of publisher, authors, number of copies in each Programme, etc.
2. Get the particulars of borrowers who have borrowed more than 3 books, but
from Jan 2017 to Jun 2017.
3. Delete a book in BOOK table. Update the contents of other tables to reflect this
data manipulation operation.
4. Partition the BOOK table based on year of publication. Demonstrate its working
with a simple query.
5. Create a view of all books and its number of copies that are currently available in
the Library.
Reference:

Download

Module - 2

Aim: Discuss the various concepts on constraints and update operations.
Program: Consider the following schema for Order Database:
SALESMAN(Salesman_id, Name, City, Commission)
CUSTOMER(Customer_id, Cust_Name, City, Grade, Salesman_id)
ORDERS(Ord_No, Purchase_Amt, Ord_Date, Customer_id, Salesman_id)
Write SQL queries to
1. Count the customers with grades above Bangalore’s average.
2. Find the name and numbers of all salesman who had more than one customer.
3. List all the salesman and indicate those who have and don’t have customers in their cities (Use UNION operation.)
4. Create a view that finds the salesman who has the customer with the highest order of a day.
5. Demonstrate the DELETE operation by removing salesman with id 1000. All his orders must also be deleted.

Download

Module - 3

Aim: Demonstrate the concepts of JOIN operations.
Program: Consider the schema for Movie Database:
ACTOR(Act_id, Act_Name, Act_Gender)
DIRECTOR(Dir_id, Dir_Name, Dir_Phone)
MOVIES(Mov_id, Mov_Title, Mov_Year, Mov_Lang, Dir_id)
MOVIE_CAST(Act_id, Mov_id, Role)
RATING(Mov_id, Rev_Stars)
Write SQL queries to
1. List the titles of all movies directed by ‘Hitchcock’.
2. Find the movie names where one or more actors acted in two or more movies.
3. List all actors who acted in a movie before 2000 and also in a movie after 2015(use JOIN operation).
4. Find the title of movies and number of stars for each movie that has at least one rating and find the highest number of stars that movie received. Sort the result by
movie title.
5. Update rating of all movies directed by ‘Steven Spielberg’ to 5.

Download

Module - 4

Aim: Introduce concepts of PLSQL and usage on the table.
Program: Consider the schema for College Database:
STUDENT(USN, SName, Address, Phone, Gender)
SEMSEC(SSID, Sem, Sec)
CLASS(USN, SSID)
COURSE(Subcode, Title, Sem, Credits)
IAMARKS(USN, Subcode, SSID, Test1, Test2, Test3, FinalIA)
Write SQL queries to
1. List all the student details studying in fourth semester ‘C’ section.
2. Compute the total number of male and female students in each semester and in each section.
3. Create a view of Test1 marks of student USN ‘1BI15CS101’ in all Courses.
4. Calculate the FinalIA (average of best two test marks) and update the corresponding table for all students.
5. Categorize students based on the following criterion:
If FinalIA = 17 to 20 then CAT = ‘Outstanding’
If FinalIA = 12 to 16 then CAT = ‘Average’
If FinalIA< 12 then CAT = ‘Weak’
Give these details only for 8th semester A, B, and C section students.

Download

Module - 5

Aim: Demonstrate the core concepts on table like nested and correlated nesting queries and also EXISTS and NOT EXISTS keywords.
Program: Consider the schema for Company Database:
EMPLOYEE(SSN, Name, Address, Sex, Salary, SuperSSN, DNo)
DEPARTMENT(DNo, DName, MgrSSN, MgrStartDate)
DLOCATION(DNo,DLoc)
PROJECT(PNo, PName, PLocation, DNo)
WORKS_ON(SSN, PNo, Hours)
Write SQL queries to
1. Make a list of all project numbers for projects that involve an employee whose last name is ‘Scott’, either as a worker or as a manager of the department that controls the project.
2. Show the resulting salaries if every employee working on the ‘IoT’ project is given a 10 percent raise.
3. Find the sum of the salaries of all employees of the ‘Accounts’ department, as well as the maximum salary, the minimum salary, and the average salary in this department
4. Retrieve the name of each employee who works on all the projects controlled by department number 5 (use NOT EXISTS operator).
5. For each department that has more than five employees, retrieve the department number and the number of its employees who are making more than Rs.6,00,000.

Download
Results

19 Comments

  16. But Australians are allowed to play at offshore online casinos because
    the law targets the operators (the casino), and not you (the player).
    Here are some of the most loved payment methods at online casinos in Australia, with minimum deposit amounts, withdrawal speed, and fees.
    We’ve made sure that the only casinos on this page
    are those that offer competitive bonuses, multiple payment
    options, and high RTP games that give you a fair chance at
    winning. As an Australian you are allowed to
    play at online casinos that are based across the
    world, just not at casinos based inside of the legal jurisdiction of
    Australia. On these pages we’ll find you top real money
    welcome bonuses, great reviews and run through everything you need to make your Australian casino online journey that little bit smoother.
    As noted above, in Australia, gambling at foreign online casinos is
    more decriminalised than it is legalized.
    It’s essential to note that individual gamblers are not targeted by US federal laws
    for placing bets online. Our assessments also consider
    time availability, and sites with 24/7 score the highest points.
    An excellent bonus becomes less appealing if it comes with impossible-to-meet
    conditions.
    The first thing that comes to mind when thinking about casino games is
    online pokies. Needless to say that there are also numerous other ways
    to deposit money at a safe Australian online casino.

    Chances are, they are more than prepared to take the world by
    storm with remarkable new bonuses and casino games.
    Our dedicated Australian online casino guide allows you to search for
    the best bonus casinos anytime you want! Online casino bonuses can be an integral part of a person’s online gambling experience.

  17. During each review, our team examines more than 200 data points which are then used to create an objective evaluation of the casino’s quality and security.
    We create a base Safety Index by looking at the size of the casino and the complaints it has received.
    At Casino Guru, we’ve developed a Safety
    Index that we use to accurately rate the trustworthiness of each casino we review.
    The bonus funds you receive will come with terms and conditions, such as wagering requirements, maximum bet
    limits, and win caps. With so many options available, finding your ideal Indian casino
    can be a tough task. We were also impressed by the quality
    of the gaming options found at BETANDYOU Casino.
    Dean Ryan brings nearly 20 years of experience in the global gambling industry.
    Our expert team evaluates each casino for game
    quality, payout speed, customer support, and local compatibility
    — including support for UPI, Paytm, and NetBanking.
    This meticulous process, combined with independent reviews from our members, ensures that we
    recommend only the most trusted and reliable casinos in India.
    A casino can only be trusted with your money and personal information if it holds a valid international license and complies with strict regulations.
    Gambling.com reviews all licensed casino websites to highlight what
    sets them apart and provides tools to make comparing them straightforward.

    Not every casino site loads perfectly in Australia, especially offshore ones.

    The only catch is that most sites won’t let you
    withdraw back to PayID, so you’ll need a backup option like crypto
    or bank transfer for cashing out. It’s one of the
    fastest ways to move AUD into your casino account, and it
    usually lands instantly. Instead of typing in long bank details, you just send
    money using your email or mobile number, simple as that.

    Some sites take Skrill but not Neteller, others
    the opposite. These wallets make it easy to deposit and get paid quickly, usually within a day or even sooner.

    References:
    https://blackcoin.co/10-minimum-deposit-casino-bonuses-in-australia-2025-guide/

  19. Schließlich ist das Spielen mit Echtgeld in deutschen Online-Casinos der Hauptgrund
    für den Besuch einer Internet-Spielbank. Wir möchten unsere Leser beim Finden der
    besten Seiten im deutschen Sprachraum mit Hinblick auf die jeweiligen Bedürfnisse unterstützen.
    Um mit Echtgeld spielen zu können, muss man zunächst eine Einzahlung platzieren. Deshalb setzen gute Online-Casinos auf die Entwicklung von guten Echtgeld-Apps für ihre
    Marke und machen den Glücksspielmarkt für den deutschen Raum tragbar
    und mobil.
    Häufig handelt es sich um solche, die bereits schlechte Erfahrung mit nicht lizenzierten Anbietern machen mussten. Für all jene, die klassische Optionen bevorzugen, bieten sich Kreditkarten an, Visa und MasterCard werden in der Regel angenommen. So steht insbesondere die in Deutschland überaus beliebte Online Wallet
    PayPal bei lizenzierten Unternehmen der Glücksspielbranche zur Verfügung.
    An die Stelle der bisherigen Casinos rücken in Deutschland nun Webseiten, die auf
    Automatenspiele geprüfter Software Entwickler konzentriert sind.

    Insbesondere wurden und werden mittlerweile nicht lizenzierte Anbieter
    abgemahnt und auf rechtliche Folgen, darunter hohe Bußgelder,
    hingewiesen.
    Finden Sie heraus, wie wir die Casinos testen, was die besten Online Casinos Ihnen zu bieten haben und worauf es bei der Wahl eines
    Glücksspielanbieters zu achten gilt! Dieses Casino bietet den aktuell höchsten Maximalbonus und überzeugt mit einem erstklassigen VIP-Programm sowie einer
    überragenden Performance auf allen Geräten. Onlinecasinoscout.de – wir werden Ihnen helfen herauszufinden, welche Online Casinos tatsächlich einen Besuch wert
    sind und welche am besten zu umgehen sind. Das macht mir persönlich in deutschen Online Casinos am meisten Spaß.

    References:
    https://online-spielhallen.de/kings-casino-rozvadov-spiele-events-e1m/

Leave a Reply

Your email address will not be published. Required fields are marked *