Docsity
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
Docsity AI
Docsity AI
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 for your university

Find the specific documents for your university's exams

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

Free resources

Our save-the-student-ebooks!

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

Database Design Exam: Cork Institute of Technology, Autumn 2011, SOFT 7002, Comp Sci, Exams of Database Management Systems (DBMS)

Aligarh Muslim UniversityDatabase Management Systems (DBMS)

The instructions and data for an autumn 2011 database design examination at the cork institute of technology. The examination covers the design of databases for recruitment agencies and project management. It includes questions on functional dependencies, primary keys, normalization, uml design, sql queries, and general database design concepts.

Typology: Exams

2012/2013

Uploaded on 03/28/2013

ramu
ramu 🇮🇳

4.4

(57)

135 documents

1 / 4

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
CORK INSTITUTE OF TECHNOLOGY
INSTITIÚID TEICNEOLAÍOCHTA CHORCAÍ
Autumn Examinations 2011
Module Title: Database Design & Programming
Module Code: SOFT 7002
School: Computing and Mathematics
Programme Title: Bachelor of Science in Information Technology Support – Year 3
Bachelor of Science (Honours) in IT Management – Year 2
Programme Code: KITSU_7_Y3
KITMN_7_Y2
External Examiner(s): Mr. Aiden Quilligan
Internal Examiner(s): Mr. Byron Treacy
Instructions: Answer all questions. Internal choice in questions 2 and 3.
Duration: 2 Hours
Sitting: Autumn 2011
Requirements for this examination:
Note to Candidates: Please check the Programme Title and the Module Title to ensure that you have received the
correct examination paper.
If in doubt please contact an Invigilator.
pf3
pf4

Partial preview of the text

Download Database Design Exam: Cork Institute of Technology, Autumn 2011, SOFT 7002, Comp Sci and more Exams Database Management Systems (DBMS) in PDF only on Docsity!

CORK INSTITUTE OF TECHNOLOGY

INSTITIÚID TEICNEOLAÍOCHTA CHORCAÍ

Autumn Examinations 2011

Module Title: Database Design & Programming

Module Code: SOFT 7002

School: Computing and Mathematics

Programme Title: Bachelor of Science in Information Technology Support – Year 3

Bachelor of Science (Honours) in IT Management – Year 2

Programme Code: KITSU_7_Y

KITMN_7_Y

External Examiner(s): Mr. Aiden Quilligan

Internal Examiner(s): Mr. Byron Treacy

Instructions: Answer all questions. Internal choice in questions 2 and 3.

Duration: 2 Hours

Sitting: Autumn 2011

Requirements for this examination:

Note to Candidates: Please check the Programme Title and the Module Title to ensure that you have received the correct examination paper. If in doubt please contact an Invigilator.

Q1. Database Design 36 Marks

You are to design a database for a recruitment agency for temporary staff.

 The agency manages the placement of its temping staff in different companies.

 Each placement has a start date and lasts for a set period (of days).

 The agency stores data on the temping staff and companies that hire the staff.

 A temping staff member, identified by their prsi#, can be placed in the same company on a

number of different occasions.

 A company, identified by their company name, can have many temp staff hired at any time.

Each company has an address and contact phone number.

 The agency stores data on their temping staff such as name, daily payrate and skill.

Placement

Prsi# Name Company Address Phone Payrate Skill Period StartDate 132 Smith.J EMC Douglas 293445 125 Admin 5 12/12/ 132 Smith.J UCC Cork 362600 125 Admin 45 01/03/ 145 Jones.P UCC Cork 362600 200 Design 25 12/11/ 999 Treacy.B CIT Wilton 489123 150 Web 30 23/03/ 132 Smith.J EMC Douglas 293445 125 Admin 5 11/08/

Note: you should have enough information to make a design but if you are confused about any

aspect of the problem, discuss the confusing issues and then proceed with a design.

a) Define a set of functional dependencies for the above application.

b) Define a primary key for the Placement table above.

c) Describe 3 processing anomalies/problems that may arise with the Placement table i.e. one

Insert, one update and one delete.

d) Use normalisation to make a new design for the application that adheres to at least 3NF.

e) Define primary keys in the new tables.

f) Draw a UML design model (diagram) for this application.

Write SQL to answer 2 of the following

1. Find the number of employees not assigned to any active or pending status projects. Avoid

the use of a Join if possible.

Blake and Clark, so answer is 2; note, Blake is assigned to P3 which is over, but NB, Clark has yet

to be assigned to any project. Make sure your code works to identify these if it was run against the

sample code, but should work in general for any data set.

2. Find names of employees that work in more than one job role on an active project

Smith and Adams work on active projects, but only Smith works on the same project in more than

one role

3. Find the number of employees assigned to each active project.

Careful, P1 has 3 assignments (one admin and two writeups) but one person is doing 2 of these

roles.

P1, 2

P4, 1

Q3. General Concepts: (Answer 2 of 3) 32 Marks (2 * 16)

3.1 Database Design:

 Discuss the advantages of UML.

 Contrast UML with Normalisation as a database design methodology.

3.2 Btrees & Indexing:

 Explain how a Btree can be an index only or a full data file organsiation?

 Explain what is meant by a balanced Btree?

 Explain why Balanced Btrees offer good performance?

3.3 DBMS V’s Traditional file based programming.

 Discuss the differences between the two approaches to data processing applications.