Ask Question, Ask an Expert


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

Application creating and populating a databasesuppose you

Application: Creating and Populating a Database Suppose you have a small retail store and decide to create a database to track sales. You have information about recent sales that you want to use for testing the database. ...

Database individual assignmentdesign a database entity and

Database: Individual Assignment Design a database (entity and relationship tables in Access) for a small college department library. You should have the entities and relationships you need to support: Purchase books Sell ...

1 objective named entity recognitionin this project you

1. Objective: Named Entity Recognition In this project, you will use scikit-learn and python 3 to engineer an effective clas- sifier for an important Information Extraction task called Named Entity Recognition. 2. Gettin ...

Database relationsusing the invoice table structure shown

Database Relations Using the INVOICE table structure shown in Table, do the following: ATTRIBUTE NAME SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE INV_NUM 211347 211347 211347 211348 211349 PROD_NUM A ...

Database systemretail store database Database system Retail Store Database: Relationships

Database system Retail Store Database: Relationships • Conduct an in-depth examination and analysis of the database, Week2_RetailStore.accdb . Apply the concepts of database systems that you have learned this week. For e ...

Questionwrite a 2 to 3 page essay describing the use of an

Question: Write a 2 to 3 page essay describing the use of an OLAP Data Cube. Your essay should also describe the operations of Drill Down, Roll Up, Slice, and Dice. Video: What is Business Intelligence and an OLAP Cube? ...

Database management systems assignment-overview-for this

Database Management Systems Assignment- Overview- For this assignment you will implement and query a database from a supplied ER Diagram and Schema.  You will be required to write the SQL statements to create the databas ...

Brief-the aim is that your team should produce a

Brief- The aim is that your team should produce a requirements document that describes the problem to be solved and captures the requirements for an information system that supports the needs of the vehicle pool manager ...

Project guidelinesoverviewthe final project for this course

Project Guidelines Overview The final project for this course is the creation of a database proposal and implementation plan report that will address the needs of a given scenario. The purpose of this assessment is to as ...

1 what is the difference between database and data

1. What is the difference between database and data warehouse? 2. What is OLAP? 3. What is a data cube? How do DSS take advantage of the structure?

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate