Docsity
Log inSign up
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search Store documents

The best documents sold by students who completed their studies

Search through all study resources
Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

University Rankings

Discover the best universities in your country according to Docsity users

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

From our blog

Exams and Study
Go to the blog

Database Engineering: File Systems, DBMS, and Data Independence, Assignments of Database Management Systems (DBMS)

Gandhi Institute For TechnologyDatabase Management Systems (DBMS)

Assignment of Database Management System For Semester

Typology: Assignments

2019/2020

Available from 10/05/2022

PriyankaSubudhi
PriyankaSubudhi 🇮🇳

3 documents

1 / 3

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Database Engineering Asignment_No1
Q1 : List three significant differences between a file-processing system and
a DBMS.
Q2: Explain the difference between physical and logical data
independence.
Q3: Construct an E-R diagram for a car-insurance company whose
customers own one or more cars each. Each car has associated with it
zero to any number of recorded accidents.
Q4: Construct appropriate tables for each of the E-R diagrams
Q5: Explain the distinctions among the terms primary key, candidate key,
and superkey.
Q6: employee (person-name, street, city)
works (person-name, company-name, salary)
company (company-name, city)
manages (person-name, manager-name)
Find the names of all employees who work for First Bank Corporation.
Q1-3CO1
Q4-5CO2
Q6CO3
pf3

Partial preview of the text

Download Database Engineering: File Systems, DBMS, and Data Independence and more Assignments Database Management Systems (DBMS) in PDF only on Docsity!

Database Engineering Asignment_No

Q1 : List three significant differences between a file-processing system and a DBMS. Q2: Explain the difference between physical and logical data independence. Q3: Construct an E-R diagram for a car-insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents. Q4: Construct appropriate tables for each of the E-R diagrams Q5: Explain the distinctions among the terms primary key, candidate key, and superkey. Q6: employee ( person-name , street , city ) works ( person-name , company-name , salary ) company ( company-name , city ) manages ( person-name , manager-name ) Find the names of all employees who work for First Bank Corporation. Q1-3CO Q4-5CO Q6CO

ANSWERS Q1 Ans  A DBMS reduces the amount of data duplication by ensuring that a physical piece of data is available to all programs authorized to have access to it, where as data written by one program in a file-processing system may not be readable by another program.  A DBMS is designed to allow flexible access to data (i.e., queries), whereas a file-processing system is designed to allow predetermined access to data (i.e., compiled programs).  A DBMS is designed to coordinate multiple users accessing the same data at the same time. A file-processing system is usually designed to allow one or more programs to access different data files at the same time. In a file-processing system, a file can be accessed by two programs concurrently only if both programs have read-only access to the file. Q2 Ans  Physical data independence is the ability to modify the physical scheme without making it necessary to conceptual or external schema.. Such modifications include changing from unblocked to blocked record storage, or from sequential to random access files.  Logical data independence is the ability to modify the conceptual scheme without making it necessary to change external schemas. Such a modification might be adding a field to a record; an application program’s view hides this change from the program. Q3 Ans Q4. person (driver-id, name, address) car (license, year, model)