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

Question - databasesuse database software such as microsoft

Question - Databases Use database software such as Microsoft Access or LibreOffice Base to perform the following actions. (Refer to Workshops 9 & 10 for help.) A. Create a new database. Add tables based on the design of ...

Assignmentproject descriptionextreme h2o is a company that

Assignment Project Description: Extreme H2O is a company that specializes in water sports. It is considering adding some new experiences for its customers. In a nearby community, there is a small river that can be used f ...

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

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

Database normalizationnormalize the below orders table to

Database Normalization Normalize the below Orders table to 3NF. Make sure to identify all the entities and their attributes, especially if you make any new items (such as entity or attributes). The following is a list of ...

The use of an access database has become very common over

The use of an Access database has become very common over the last 10 years. Access is the preferred desktop database because server databases such as structured query language (SQL) and others are too complex and are be ...

Computer sciencein reference to your database design

Computer Science In reference to your Database Design Proposal: Proposal Outline, provide a narrative analysis of the customer and user needs by defining the customers and users as well as describing their individual nee ...

Assignment database modeling and normalizationimagine that

Assignment: Database Modeling and Normalization Imagine that you work for a consulting firm that offers information technology and database services. Part of its core services is to optimize and offer streamline solution ...

Task - overview of business casealive amp boating aampb is

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

Some people used to believe that data warehouses would

Some people used to believe that data warehouses would quickly replace databases for both online transaction processing (OLTP) and online analytical processing (OLAP). Of course, they were wrong. Why can data warehouses ...

  • 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