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

Database designfrom textbook fundamentals of database

Database Design From Textbook: Fundamentals of Database Management Systems 2nd Edition. 1. Convert the Video Centers of Europe, Ltd., entity-relationship diagram in Exercise 2.2 into a well structured relational database ...

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

Homeworkgiven the relations below answer the following

HOMEWORK Given the relations below, answer the following queries using SQL. Note that the tables contain sample records only and do not represent all the possible records that could be stored in these tables. MEMB ERS ME ...

Database design discusion 150 wordsnormalizationplease

Database Design Discusion (150 words) Normalization Please respond to BOTH of the following questions: Question A In your own words discuss the benefits of normalization. Question B Do you think we should normalize our d ...

Assignment advanced relational databaseproject- advance

Assignment: Advanced Relational Database PROJECT- Advance SQL Overview: Using the knowledge garnered thus far, please solve all of the below problems. Please run the attached SQL script file at the SQL*PLUS prompt. This ...

Discussionnormalization and redundancy please respond to

Discussion "Normalization and Redundancy" Please respond to the following: • Suggest one of the problems that normalization seeks to solve within a database. Describe one example of your suggested problem, and explain th ...

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

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

Ngocbo database projectthe purpose of this project is to

NGO/CBO Database Project The purpose of this project is to build a database to store and retrieve basic information on NGOs/CBOs collected through a questionnaire given in the Appendix. Database Specifications In view of ...

1 analyse situations andor environments for the application

1) Analyse situations and/or environments for the application of database solutions including web connectivity 2) Create, alter and remove relational tables, indexes and data using an appropriate database language. 3) Ex ...

  • 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