Search for notes by fellow students, in your own course and all over the country.
Browse our notes for titles which look like what you need, you can preview any of the notes via a sample of the contents. After you're happy these are the notes you're after simply pop them into your shopping cart.
Document Preview
Extracts from the notes are below, to see the PDF you'll receive please use the links above
The Independent Institute of Education
2013
MODULE NAME:
MODULE CODE:
DATABASE INTRODUCTION
DATA6211
ASSESSMENT TYPE:
EXAMINATION
TOTAL MARK ALLOCATION:
120 MARKS
TOTAL HOURS:
3 HOURS (+15 minutes reading time)
(PAPER ONLY)
STUDENT NAME:
STUDENT NUMBER:
INSTRUCTIONS:
1
...
2
...
3
...
You may make notes on your question paper,
but not in your answer sheet
...
4
...
5
...
Hand in
all the pages of this test/ examination question paper as well as your answer script
...
Answer all the questions on the answer sheets or in answer booklets provided
...
7
...
Use the mark allocation as a guideline as to how much time to
spend on each section
...
This is a closed book examination
...
In your answer booklet,
write down only the number of the question and, next to it, the letter of the correct answer
...
Q
...
1
Which of the following best describes a record?
(a)
(2)
Complete set of data fields;
(b) Single unit of information;
(c)
Collection of files;
(d) Stored information;
(e)
Q
...
2
None of the above
...
1
...
Which of the following is not true about primary keys?
(a)
(2)
A primary key should be numeric;
(b) A primary key can change over time;
(c)
A primary key should be meaningless;
(d) A primary key can be a foreign key;
(e)
All of the above
...
1
...
1
...
Which of the following best describes Data Definition Language?
(a)
(2)
Statements used to enter data into tables;
(b) Statements used to control users access to tables;
(c)
Statements used to implement security;
(d) Statements used for the creation and deletion of tables;
(e)
Statements used for Data Mining
...
In your answer booklet,
write down only the number of the question and, next to it, the letter of the correct answer
...
Q
...
1
Table form when every attribute in the row is functionally dependent upon the whole key, not (2)
just part of the key;
(a)
First Normal Form;
(b) Second Normal Form;
(c)
Third Normal Form;
(d) Forth Normal Form;
(e)
Q
...
2
Fifth Normal Form
...
(2)
© The Independent Institute of Education (Pty) Ltd 2013
Page 3 of 8
The Independent Institute of Education
(a)
2013
Domain;
(b) Cardinality;
(c)
Relationship;
(d) ERD;
(e)
Q
...
3
All of the above
...
(a)
(2)
Data definition language;
(b) Data control language;
(c)
Data manipulation language;
(d) Data security language;
(e)
Q
...
4
Data safety language
...
2
...
Which model is independent of individual applications, database management systems and
(2)
hardware?
(a)
Conceptual;
(b) Hierarchical;
(c)
Perceptual;
(d) Data;
(e)
DDL
Question 3
(Marks: 20)
Provide the term(s) that best describes each statement below
...
© The Independent Institute of Education (Pty) Ltd 2013
Page 4 of 8
The Independent Institute of Education
2013
Entity Relationship
Diamond
Associative addressing
Drop
Preliminary Planning
Required data
Specialisation
Committed
Column subset
Data Structure
Data Control Language
Null
Redundancy
Data Model
Circle
Data Analysis
Query Processor
Validity Checking
Database
Database Plan
Manager
Database management
First normal form
Second normal form
systems
Third normal
form
Q
...
1
Designed to maintain large volumes of data
...
3
...
(2)
Q
...
3
Information obtained is used to determine relationships between applications and find uses
(2)
of application information
...
3
...
(2)
Q
...
5
Model based on real-world perception
...
3
...
(2)
Q
...
7
Diagram used to represent the design of a network model
...
3
...
(2)
Q
...
9
Acts as an interface between the data stored in the database and the queries submitted to
(2)
the database system
...
3
...
Question 4
(2)
(Marks: 10)
© The Independent Institute of Education (Pty) Ltd 2013
Page 5 of 8
The Independent Institute of Education
2013
A new further education college has opened in your city
...
The college contains information about lecturers, courses, students and results
...
Produce a report to convince the founder
of why a database should be created to manage the college
...
Using this method, you can, reduce redundancy in a table and eliminate the problems of
inconsistency and disk space usage
...
Q
...
1
Provide a brief explanation of Normal Forms (NF) 1 to 3
(6)
Q
...
2
Provide an example for each conversion in the normalization process
...
Question 6
(Marks: 10)
Discuss the SQL command that will produce this result from the Customer table:
Name
Phone Number
Bill Bloggins
001 701-866-1911
Jack Frost
001 701-361-1111
Billy Spook
027 11-858-9312
Joe Schmoe
027 32 -765-0904
Joseph Dlamini
045 332-893-9090
Q
...
1
Write the SQL command to generate the previous table
...
6
...
Write the SQL code to
Equi-join the CUSTOMER table and the PRODUCT table including all attributes in each table:
CUSTOMER TABLE
Cust -No
Name
City
Phone-No
C495038
Bill Bloggins
BISMARK
001 701-866-1911
C495047
Jack Frost
FARGO
001 701-361-1111
C495082
Billy Spook
JOHANNESBURG
027 11-858-9312
C495034
Joseph Dlamini
LONDON
045 332-893-9090
PRODUCT TABLE
PROD-NO
MODEL
DESC
PRICE
PROD-CITY
P36789105
FORD F150
Truck
R350 000
BISMARCK
P89056032
INFINITI G50
Sedan
R550 000
FARGO
P86745321
BMW650I
Sedan
R750 000
JOHANNESBURG
P35097832
BMW320I
Sedan
R455 000
LONDON
Question 8
(Marks: 35)
Q
...
1
What is NULL in the database context? Give an example
...
8
...
8
...
8
...
Write the T-SQL code
...
8
...
Write the code