Assingment 1

Topics: Database, Database management system, Computer Pages: 3 (663 words) Published: November 17, 2014
ITC6000-Assignment 1
1. File Structure
1.1. How many records does this file contain? 13 records
1.2. How many fields are there per record? 8 fields per record 1.3. What problem would you encounter if you tried to create a listing by last name? There are several records under same last name, so if they list by the last name same record will be stored unnecessarily.(Data redundancy) 1.4. What are field names? First, Last name, ID,Hours,GrossPay,Withholding,NetPay,PayDate 1.5. What other problems do you see?

2. Answer in paragraph form
2.1. A database system is made up of five major parts. Identify these parts. Provide specifics of what make up these components. A database system is made up of five components and they are Hardware, Software, People, Procedures and data. Hardware

Hardware refers to all of the physical electronic devices such as computers, storage devices, and network devices etc. Software
Software is the set of programs used to handle the database and to control and manage the overall computerized database. There are three types of software are included: Operating system software is what manages all the hardware components that make it possible to run on the computers. Example: Windows, Linux DBMS software manages the database within the database system. Example: SQL server Applications and utility software are used to access and use data in the DBMS and to manage the computer environment. Application programs developed in programming languages such as C++, Visual Basic that are used to access database in database management system. Utilities are the tools that helps to to manage the computer components such as anti-virus programs. People

People are the users who mange the databases and preform different operations on the databases in the system. There are five types of users: System administrators, database administrators, Database designers, system analysts and programmers, and End users.

Procedures
Procedures refer...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • MKT 571 Quizzes week 1 6 Essay
  • APUSH Chapter 1 Cornell Notes Essay
  • Maths Paper 1
  • A1 1 2SimpleMachinesPracticeProblems Essay
  • Class 10 Maths Sa-1 Essay
  • eco349 mid summer2 2013 mc sol 1 Essay
  • Printable Flashcard On IT302 Quiz 1 Fr Essay
  • 2014 15 Day 1 and Day 2 BIC Secondary School Calendar 1 Essay

Become a StudyMode Member

Sign Up - It's Free