Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

problem 1)a) Define clustering.

b) describe the functions of File manager?

c) What do you mean by the 2NF rule.

d) What are the integrity rules?

e) prepare down the advantages of E/R model?

f) describe the differences between trivial and nontrivial dependencies.

g) Define parameterized cursors.

h) Describe the various types of triggers.

i) prepare down the difference between function and procedure?

j) describe the advantages of relational algebra.

problem 2) The following relations structures are given:-

S(S#, SNAME, STATUS, CITY) PRIMARY KEY(S#)
P(P#, PNAME, COLOR, WEIGHT, CITY) PRIMARY KEY(P#)
SPJ (S#, P#, J#, QTY) PRIMARY KEY (S#, P#, J#)
FOREIGN KEY (S#) REFERENCES S
FOREIGN KEY (S#) REFERENCES P
FOREIGN KEY (J#) REFERENCES J

a) prepare a command to get project numbers for projects supplied with at least all parts available from supplier S1.

b) prepare a command to get supplier numbers for suppliers who supply the same part to all projects.

c) prepare a PL-SQL to get part numbers of parts supplied to some project in an average quantity of more than 320.

d) Create the view consisting of supplier tuples for suppliers that are located in London.

e) What are 1NF, 2NF and 3NF rules?

DBMS, Programming

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

Have any Question? 


Related Questions in DBMS

Assignment database environment proposalas one of the

Assignment: Database Environment Proposal As one of the program outcomes for the Bachelor of Science in Information Technology program, students must design and develop a database using professional principles and standa ...

Database design assignmentpart 1customer resource

Database Design Assignment Part 1 Customer Resource Management Database You have been tasked to develop a set of tables for a customer resource management database. You are required to store the following information in ...

A task descriptionoverviewyour task is to create and test a

A. Task Description Overview Your task is to create and test a database in MySQL using PhpMyAdmin. You are provided with a scenario and supporting documents, describing the requirements that Southern Cross University may ...

Restaurants and fast-food chains rely heavily on business

Restaurants and fast-food chains rely heavily on business intelligence to make important decisions. Casinos do as well. Some of the leading restaurants, fast-food chains, and casinos using data warehouses include AFC Ent ...

Project database and programming designthis assignment

Project: Database and Programming Design 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 a ...

Assignment1write a query that retrieves studentlastname

Assignment 1. Write a query that retrieves student.last_name, student.first_name and total number of enrollments from the student and enrollment tables. Your query should also include students that do not have any enroll ...

Replacement china incproject descriptionyou work as an

Replacement China, Inc. Project Description: You work as an associate database manager at Replacement China, Inc. This firm specializes in finding difficult-to-replace, no-longer manufactured china, crystal, silver, and ...

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

Warehouse management system projectproject deliverablesthe

Warehouse management system project Project Deliverables The project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. Note that in the phase 3, ...

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