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

Enterprisebim projectgoal - to enable students to

Enterprise/BIM Project Goal - To enable students to experience the process of building a non-trivial database-backed web application. Tasks 1. Choose any area that interests you - this does not necessarily have to be abo ...

Relational databases with ms access1 create a table

Relational Databases with MS Access 1) Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run 2) Your code (for the button) will dynamically read the caption from the table and assign it t ...

Describe a dbms and its functions list at minimum three of

Describe a DBMS and its functions. List, at minimum, three of the popular DBMS products and give a brief description of each. Your response should be at least 200 words in length. Explain what mobile devices are and why ...

Relational database systems comp 1005objective this is an

Relational Database Systems (COMP 1005) Objective: This is an individual assignment aimed to give the student exposure in understanding, designing, building and analyzing database systems for a given real-time based scen ...

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

Question 1use the tables below to answer the following

Question 1: Use the tables below to answer the following questions: customerid customerid firstname lastname city state 10101 John Gray Lynden Washington 10298 Leroy Brown Pinetop Arizona 10299 Elroy Keller Snoqualmie Wa ...

Use sql management studio to create a database called

Use SQL Management Studio to create a database called ITCO630_P1.MDF. Be sure to store the database in a location that you will remember. Add the following tables and data to the database. Use the appropriate field types ...

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

Ms access database assignment helpdo the easy way i really

MS ACCESS Database assignment help (DO THE EASY WAY I really just need this asap) (I have the database file ready to email to you. I dont think it let me upload the database file here.) Create a simple excel spreadsheet ...

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

  • 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