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

Taskoverview of business casealive amp boating aampb is a

Task Overview of business case: Alive & Boating (A&B) is a small start­up company that sells small boats in Wagga. A&B keeps its models in several showrooms across the city. At this stage customers cannot view the availa ...

Use sql management studio to create a database called

Use SQL Management Studio to create a database called ITCO630_P1.MDF. Be sure to store the database in a location that you will remember. Add the following tables and data to the database. Use the appropriate field types ...

Discussionyou have been asked to help a critical

Discussion You have been asked to help a critical infrastructure company in analyzing the privacy and security of a SCADA system. Conduct research on the topic and answer the following: 1. How would you describe general ...

Apriori analysis and cluster analysis-data analysis

ApriorI analysis and Cluster analysis-Data Analysis assignment CLUSTER ANALYSIS The purpose of this assignment is to demonstrate steps performed in a K-Means Cluster analysis. Review the "k-MEANS CLUSTERING ALGORITHM" se ...

The strayer oracle server may be used to test and compile

The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server. A multina ...

Lab modifying a database design in visiothis assignment

Lab: Modifying a Database Design in Visio This assignment contains two Sections: Visio Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment. Use "Appendix A: De ...

Prepare a brief report that describes how data warehouses

Prepare a brief report that describes how data warehouses and online transaction processing complement each other. In your report make sure to include the following: • Why do companies use data warehouses? • What are the ...

Tasks objectives1 manage client-server connections using

Tasks Objectives: 1. Manage client-server connections using RDBMS Net Services 2. Evaluate requirements and select appropriate parameters to ensure effective storage management in a database system 3. Manage Redo log inf ...

Projectfalcor supplies is a distributor of high tech

Project Falcor Supplies is a distributor of high tech teaching equipment. Its primary target customers are schools in the region who purchase the teaching equipment for classrooms and online use. The company's main compe ...

Homeworkunlimited pickers is a group of workers who have

Homework Unlimited Pickers is a group of workers who have joined together to provide harvesting services to farmers who need to have their crops brought in. The organization has many teams of workers who travel from loca ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen