Assignment1

Topics: Question, Database, Database management system Pages: 1 (354 words) Published: February 9, 2015
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...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Assignment1 Research Paper
  • Assignment1 Essay
  • Assignment1 Essay
  • Assignment1 Essay
  • Assignment1 Essay
  • MS2 Assignment1 Essay
  • Essay about Assignment1
  • assignment1 Essay

Become a StudyMode Member

Sign Up - It's Free