10 IST‎ > ‎7. Database Design‎ > ‎

2. Components of a Database

FOCUS OUTCOME STATEMENT:

  • 5.2.3 critically analyses decision-making processes in a range of information and software solutions
  • 5.3.1 justifies responsible practices and ethical use of information and software technology
  • 5.4.1 analyses the effects of past, current and emerging information and software technologies on the individual and society
  • 5.2.3 critically analyses decision-making processes in a range of information and software solutions
  • 5.5.1 applies collaborative work practices to complete tasks

STUDENTS LEARN ABOUT:

  • Data and information
    • importance of information to society, particularly in electronic form

  • Legal issues such as : 
    • copyright/licensing 
      • intellectual property
    • security and protection including viruses
    • legislation such as Anti-discrimination, Equal Employment Opportunity, Occupational Health and Safety

  • Ethical issues such as:
    • code of practice and conduct
    • accuracy, validity and bias of data

  • Database development
    • components of a database
    • inputs of the database
    • data types required to solve a problem, such as:
      • text and hypertext
      • graphics
      • audio
      • video
      • animation

  • Collecting, organising and storing data
    • sources of data to solve a problem
    • database storage on a storage medium considering file size, portability and updatability
    • validation and verification checks of data

  • Integration
    • importing from existing electronic data

  • Data storage and function
    • primary storage such as RAM and ROM
    • secondary storage such as random and sequential access
    • secondary storage media such as tape, disk and optical media
    • database storage on a storage medium considering file size, portability and updatability

  • Roles and Responsibilities
    • of people working in the information and software technology field such as
      • data entry operators
      • systems analysts
      • users

STUDENTS LEARN TO:
  • Data and information
    • define and compare data with information
    • explain the process of deriving information from data

  • Legal Issues:
    • examine legal issues as they apply to the development of information and technology software solutions

  • Ethical issues 
    • research and report on ethical issues relating to the development of information and software technology solutions
    • examine and judge accuracy, validity, bias of data and info

  • Database development
    • describe the relationships between a database, file, record, field and data, character
    • list input data
    • identify outputs when designing a database
    • create a data dictionary to illustrate and describe data types
    • describe and manipulate data types for a range of purposes

  • Collecting, organising and storing data
    • document and acknowledge data sources
    • use validation and verification checks on the data for a database
    • input data and store for a given problem

  • Integration
    • import data from a different source

  • Data Storage and Function
    • contrast primary and secondary memory
    • describe the functions of primary and secondary memory
    • select and use the appropriate data storage media for a given situation in an ethical manner
    • state the reasons for the range of data storage and media formats

  • Roles & Responsibilities
    • describe key roles within the information and software technology field and critically analyse possible role stereotypes
    • develop role descriptions of people working in the field of information and software technology
 



Data vs. Information

    
DataInformation
MeaningData is raw, unorganized facts that need to be processed. Data can be something simple and seemingly random and useless until it is organized.When data is processed, organized, structured or presented in a given context so as to make it useful, it is called information.
ExampleEach student's test score is one piece of data.The average score of a class or of the entire school is information that can be derived from the given data.
Etymology"Data" comes from a singular Latin word, datum, which originally meant "something given." Its early usage dates back to the 1600s. Over time "data" has become the plural of datum."Information" is an older word that dates back to the 1300s and has Old French and Middle English origins. It has always referred to "the act of informing, " usually in regard to education, instruction, or other knowledge communication.




Access: Introduction to Objects




Structure of a Database

Database
  • A collection of related information for a business purpose
  • For example, A library database including data about Borrowers, Books, etc

File / Table
  • This is a collection of related information about a specific entity.
  • There must be one or more Files/Tables in a Database
  • For example, a list of Borrowers in a Library Database

Record / Row
  • This is one instance of information from a table/file.   
    There are zero or more records in a File/Table
  • For example, a specific borrower like Johnny Vegas who lives in 26 Grange Road
Fields
  • This is one component part of a record.
  • There must be one or more fields in each record
  • For example, Name, Address, etc.

Character or Data Types
  • Each field can be defined by a particular data type
  • For example, Text, or Numbers, Boolean, OLE Data, Dates, Currency




 
Student Activity

Access 2013: Working with Databases


Access: Working with Tables


Complete the following workbook...

Instructions:
1. Open up Google Doc
2. Make a Copy of it
3. Download Doc as a Word Doc and save it




Comments