Assignment1

ITC6000 – Assignment 1

Please answer the following questions:
Question- 1
Use the table in the data file below to answer these questions regarding file structure:
1.
2.
3.
4.
5.

How many records does this file contain?
How many fields are there per record?
What problem would you encounter if you tried to create a listing by last name?
What are the field names?
What other problems do you see?

Data File
File Structure
First
Roger
Roger
Telly
Telly
Telly
Telly
Telly
Telly
Grant
Grant
Alarry
Betty
Samuel

Last Name
McHaney
McHaney
O'Grady
O'Grady
O'Grady
O'Grady
O'Grady
O'Grady
Brikestein
Brikestein
Abu
Marygrade
Timod

ID
1
1
2
2
2
2
2
2
3
3
4
5
6

Hours
38.5
38.5
30
30
20
20
44.5
44.5
18
18
40
35
40

GrossPay
$561.56
$561.56
$489.06
$489.06
$326.04
$326.04
$725.44
$725.44
$408.60
$408.60
$728.80
$792.40
$927.20

Withholding
$112.31
$112.31
$97.81
$97.81
$65.21
$65.21
$145.09
$145.09
$81.72
$81.72
$145.76
$158.48
$185.44

NetPay
PayDate
$449.25 10/23/2000
$449.25 1/17/2000
$391.25 3/1/2000
$391.25 2/22/2000
$260.83 2/28/2000
$260.83 3/6/2000
$580.35 1/21/2000
$580.35 1/17/1998
$326.88 10/23/2000
$326.88 1/17/2000
$583.04 1/17/2000
$633.92 1/17/2000
$741.76 1/17/2000

Question- 2
Answer the following two questions in paragraph form:
1. A database system is made up of five major parts. Identify these parts. Provide specifics of what make up these components.
2. A DBMS provides at least nine functions. Identify these functions and provide a brief explanation of each
Question – 3
A conceptual model provides a bird's-eye view of a database. Conceptual models are derived from the business rules that make up an application. From the following business rules, create a conceptual model. First, identify the entities involved in the problem, and then determine the relationships that exist between entities. Finally, draw a conceptual model.
Business Rules:
An author writes books.
A book is written by one or more authors.
A book has one subject.
A subject has at least 20 books.