Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Answer all the problems.

1) describe file organization? Name all the file organization techniques. Make a detailed comparison among all the file organization techniques.   

2) What are the functions related with role of the database administrator? How does data dictionary help a database administrator?           

3) Define following terms.                                  

 (i) Inverted list.

(ii) Referential integrity.

(iii) Foreign key.

(iv) Transaction.

(v) Candidate key.                           

4) Compare and contrast the following.                            

(i) Primary indices and Secondary indices.

(ii) Centralized DBMS and Distributed DBMS.

(iii) B tree and B+ tree.

(iv) Data replication and data Fragmentation.

(v) Procedural and non procedural DMLs.           

5) Describe normalization. prepare the conditions under which relation requires to be normalized to 2NF and 3NF with the help of an ex.

6) Project handling organization has persons identified by PER – ID and a LAST – NAME. Persons are assigned to departments identified by DEP – NAME. Persons work on projects and each project has a PROJ – ID and a PROJ – BUDGET. Each project is managed by one department and the department might manage many projects. But the person might work on only some (or none) of the projects in his or her departments. Identify entities and relationship for this organization and construct an E – R diagram.

7) Describe the role of hashing function in direct file organization.   

8) Consider following tables in database:

    Employee (Emp_No, skill, Pay_Rate)

    Duty Allocation (Posting_No, Emp_No, day, shifts)

prepare SQL statements for performing the following tasks:

(i) Retrieve shift details for employee named “Vijay”.

(ii) Get a count of different employees on each shift.

DBMS, Programming

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

Have any Question? 


Related Questions in DBMS

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

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

Data warehouses and data martswrite a one- to two-page

Data Warehouses and Data Marts Write a one- to two-page (250-500 word) paper that discusses the differences between data warehouses and data marts. Also, discuss how organizations can use data warehouses and data marts t ...

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

Your team is a consulting company that specializes in rapid

Your team is a consulting company that specializes in rapid application development. A client company wishes to improve their customer data and interactions records. You create a simple customer relationship system for t ...

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

Moving average forecasting modelsmoving average forecasting

Moving Average Forecasting Models Moving average forecasting models are powerful tools that help managers in making educated forecasting decisions. A moving average is mainly used to forecast short historical range data. ...

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

Career opportunities in your majorknowledge workers

CAREER OPPORTUNITIES IN YOUR MAJOR Knowledge workers throughout the business world are building their own desktop databases (often called end-user databases or knowledge worker databases). To do so, they must understand ...

1 draw and explain erm diagram andnbsp explain what is

1. Draw and explain ERM diagram and  explain what is REM 2. Explain what is Normalization . what is 0NF,1NF, 2NFand ,3NF and explain what is in the tables Entity Relationship Modeling and Normalization: 1 System Analysis ...

  • 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