Information Technology

Database

· What is the difference between data and database?

· What are the advantages and disadvantages of the database vs. file processing approach to data management?

· What is a relational database management system?

Telecommunication

· What are involved in telecommunication?

· What are the components of a telecommunication system?

· What is a telecommunication network?

· What are the applications of telecommunication?

---

Data hierarchy (Bit, Byte, Field, Record, File, Database)

Database vs file processing

· Data independence

· Data consistency

· Data redundancy

· Data sharing

Database management systems

· Data definition language

· Data manipulation language

· Data dictionary

Relational DBMS

· DDL à tables

· DML à SQL

Hands-on activity: pg.243 ex.#3

---

Telecommunication -- electronic communication over some distance

Telecommunication systems functions

· transmits information

· establishes a path/connection between the sender and receiver

· directs messages along the most efficient paths

· ensures messages reaching the right receiver

· edits data by performing error checking and reformatting

· converts messages from one device to another

· controls information flow

Telecommunication systems components
1. computer (process information)
2.  input/output devices (send/receive data)
3.  communication channels (twisted wire, fiber-optic, coaxial cable, microwave, satellite)
4.  processors (modem, multiplexer, controller, concentrator)
5.  software (network, access, transmission, error, and security controls)

Telecommunication network

· Topology (star, bus, ring)

· Scope (PBX, LAN, WAN, VAN, Internet*)

· Standards (TCP/IP, ISDN)

Internet

· History

· Terminology (URL, HTML, Browser, Search engine)

Telecommunication applications

· e-mail, voicemail, fax

· teleconferencing, videoconferencing

· electronic data interchange

· e-commerce