Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

problem 1) prepare a detailed note on Referential Integrity.

problem 2) What do you understand by Decomposition of Relation Scheme?

problem 3) prepare down the functions of DBA.

problem 4) Distinguish between Weak Entity and Strong Entity with appropriate ex.

problem 5) Consider the following database relations:

Country(Con-code, Name, Capital)
Population (Pop-code, Population)

Country and Population are related with one to one relationship.

Create relational database for the above and convert it in 3NF and solve the given queries in SQL :

(i) List highest population country.

(ii) Give name and population of country whose capital is ‘Delhi’.

(iii) Print Countrywise Population.

problem 6) Consider the given relation:

Teacher (tno, tname, collegename, dept.)
Etest (eno, testname)

Teacher and Etest are related with many to many relationship.

Create a relational database for the above and convert it in 3NF and solve the following queries in SQL:

(i) Count no. of teachers who passed ‘Set Exam’ of Computer Science.

(ii) Delete all teacher details of ‘Maths’ Dept.

(iii) Print total no. of teachers passing respective exam.

problem 7) Consider the following relation:
Employee (empno, empname, salary, comm., desg.)
Department (deptno, deptname, location)

Employee and Department are related with many to one relationship.

Create relational database for the above and convert it in 3NF and solve the following queries in SQL:

(i) Determine employees who are working at Ahmednagar city location.

(ii) Find maximum, minimum and average salary for every designation.

(iii) Update commission for every employee by 5% who belongs to ‘Computer Department’.

problem 8) Consider the given relation:

Item (I_no, I_name, I_qty)
Po (p_no, p_date, cost, qty)
Supplier (s_no, s_name, s_addr.)

Item and Po are related with one to many relationship and supplier and Po are related with one to many relationship.

Create a relational database in 3NF and solve the following queries in SQL :

(i) Find out po_no, po_date and supplier_name of Po which is maximum amount.

(ii) List name of supplier to whom Po is given for ‘Mouse’.

(iii) List name of supplier who is going to supply ‘Monitor’ with minimum cost.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M95353

Have any Question? 


Related Questions in DBMS

Relational databases with ms access1 create a table

Relational Databases with MS Access 1) Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run 2) Your code (for the button) will dynamically read the caption from the table and assign it t ...

Assignmentcreate a simple excel spreadsheet with data to

Assignment Create a simple excel spreadsheet with data to update the database. 1. Create a form (frmUpdateMediaLink) to link the spreadsheet to a table in the database (you can link the spreadsheet manually using the wiz ...

Fundamentals of databases assignment 1 -q1 explain the

Fundamentals of Databases Assignment 1 - Q1. Explain the distinction between total and partial constraints. Q2. Explain the difference between a weak and a strong entity set. Q3. Explain the distinction between disjoint ...

How up-to-date should data warehouse information

HOW UP-TO-DATE SHOULD DATA WAREHOUSE INFORMATION BE? Information timeliness is a must in a data warehouse-old and obsolete information leads to poor decision making. Below is a list of decision-making processes that peop ...

Make the menageriegis database using petgissqllook at the

Make the menagerieGIS database using petGIS.sql Look at the petGIS.png to see where the pets are. 1. Display the name, astext location, X and Y values of each pet 2. Display the pets with their location displayed in stan ...

Option simulation preparation paperby the end of module 2

Option : Simulation Preparation Paper By the end of Module 2, you will have received the URL, team name (also known as logon ID), and password for the Littlefield Simulation site from your instructor. This week, you must ...

Objective this is an individual assignment aimed to give

Objective: This is an individual assignment aimed to give the student exposure in understanding, designing, building and analyzing database systems for a given real-time based scenario and be able to conduct optimal stra ...

Oracle erp systemsoracle provides erp solutions for

Oracle ERP Systems Oracle provides ERP solutions for mid-size business organizations. For this assignment, you are to write a research report on these ERP solutions. Your report should include: • a description of Oracle ...

Create a database to keep inventory of something you own

Create a database to keep inventory of something you own, such as books, CDs, movies, collectibles, etc. You can make these up if you want. (You could use this in real life to keep track of what other people have borrowe ...

Save a copy of the tal distributors database located within

Save a copy of the TAL Distributors database located within the Shared Files of the course. You will use this copy to create indexed fields in your database. The current TAL Distributors database only has a few customers ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro