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

1 what is the most popular database model2 how are primary

1. What is the most popular database model? 2. How are primary and foreign keys different? 3. What are the five important software components of a database management system? 4 What are the four major types of data-minin ...

Describe a dbms and its functions list at minimum three of

Describe a DBMS and its functions. List, at minimum, three of the popular DBMS products and give a brief description of each. Your response should be at least 200 words in length. Explain what mobile devices are and why ...

Select one of the four primary categories of terrorist

Select one of the four primary categories of terrorist hazards (Chemical, Biological, Radiological/Nuclear, Explosives). Provide a history of its use as a weapon of mass destruction (WMD); describe how it is made and dis ...

Discussionatleast 1 paragraph for each partpart 1 remote

Discussion Atleast 1 paragraph for each part Part 1: "Remote Access" Please respond to the following: • Remote access to corporate resources is becoming commonplace. From an auditing perspective, suggest two or more cont ...

Database analysis and designimplement the initial database

Database Analysis and Design Implement the initial database design for the Enterprise Resource Planning conceptual model described by the following requirements in your selected RDBMS. You need to create the Entity-Relat ...

Assignmentthis assignment consists of two sections a design

Assignment This assignment consists of two sections: a design document and a revised Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file nam ...

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 ...

Organizations want information organizations need

Organizations want information. Organizations need information. However, information must be in an organized format that supports the creation of business intelligence. Otherwise, according to Rebecca Wettemann, vice pre ...

Dfd1 draw a context diagram for the fiat for football

DFD 1. Draw a Context Diagram for the FIAT for Football process. 2. Draw a top level Data Flow Diagram for the FIAT for Football method. 3. Blow up any one non-trivial process into a first level Data Flow Diagram.

Assignmentthis must be your own unique work you cannot have

Assignment THIS MUST BE YOUR OWN UNIQUE WORK: you cannot have the exact same table as another student and you cannot turn in something you find online!Your work will be checked against a plagiarism database. The format m ...

  • 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