Class Notes (1,100,000)
US (490,000)
UK (1,000)
ICT (100)
ICT 301 (10)
Lecture 5

ICT 301 Lecture Notes - Lecture 5: Logical Address


Department
Information Communication Technology
Course Code
ICT 301
Professor
joekratzat
Lecture
5

This preview shows half of the first page. to view the full 3 pages of the document.
Basic Concept Notes
Chapters 1 and 2
Database Processing: The New Way
The main idea of a database is that a third structure lies between the application program
and the data
The third structure is known as the Database Management System (DBMS):
stores all the information about the physical location of data
The application refers to the data by logical address, and the DBMS converts the logical
address to a address to access the data
There are multiple ways that a DBMS could organize data
What is a Database?
Database: a structured set of data held in a computer (organized data)
Developing a Database:
When building a database, build it one step at a time.
Break the task of building a database into distinct phases, then subdivide the phases into
smaller, manageable tasks. Complete the tasks one at a time until they’re all done
Database vs. Database Application
A database is a collection of records that has well-defined characteristics
A database is not a kind of computer program
A database application is a program that is designed to operate on the data stored in the
database
It is the database application that creates the screens the user looks at, the forms
into which updates are made, and the reports that are printed out
The Entity-Relationship Model
Chapter 4
Exploring the Structure of the ER Model
The ER model can be used to represent a wide variety of systems that people want to
track in some detailed manner
The system can be physical (space shuttle), or conceptual (financial records)
The ER diagram uses four elements:
Entities
Something that a user can identify and wants to keep track of
Entities of a given type are grouped together into entity classes
Ex: Employee would be an entity class
find more resources at oneclass.com
find more resources at oneclass.com
You're Reading a Preview

Unlock to view full version