Identify the 4 main functions of a DBMS
- Database development
- Database query
- Database maintenance
- Application development
Identify 9 components of a LAN
- Node
- Workstation
- Server
- Network Interface Card (NIC)
- Transmission media
- Network Operating System (NOS)
- Communications Device
- Communication/Network Protocols
- Gateways and Routers
Identify the 2 types of networks that can be used to provide WAN communications services
Value added network: Privately owned communication network that provides additional services beyond standard data transmission
Internet-based network: Uses Internet protocols and public communications channels to establish network communications
List some of the features of a value added network (VAN)
- Privately owned
- Provides additional services
- Provides good security
- Uses periodic (batch) processing
- May be expensive
List some of the features of an Internet-based network
- Uses public communications channels
- Transmits transactions immediately
- Relatively affordable
- Increases the number of potential trading partners
What is the difference between an intranet and an extranet?
Intranet - connects geographically separate LANs within a company
Extranet - permits specified external parties to access the company’s network
What is the basic difference between a database and a database management system?
Database - integrated collection of data records and data files
Database management system (DBMS) - software that allows an organization to create, use, and maintain a database
What is a data warehouse and what is data mining?
Data warehouse - collection of databases that store both operations and management data
Data mining - processing of data in a data warehouse to attempt to identify trends and patterns of business activity
What are some advantages of a DBMS?
- Data redundancy and inconsistency are reduced
- Data sharing exists
- Data independence exists
- Data standardization exists
- Data security is improved
- Data fields can be expanded without adverse effects on application programs
- Timeliness, effectiveness, and availability of information is enhanced
What is the basic difference between WANs and LANs?
Distance
LANs normally are within a fairly limited distance, and WANs allow a much longer distance
What are some of the similarities and differences between the Internet, intranets, and extranets?
All use Internet protocols and public communication networks rather than proprietary protocols and networks so that the same browsers can be used.Intranets connect LANs within a company.
Extranets allow a company’s customers and suppliers to access the company’s network.
