Name: Leomar James R. Canopin Discussion Questions #9

IT 193 - Systems Analysis & Design

Chapter 9: Data Design

1. Explain the main difference between a file processing system and a database system.
Answer: File processing is the method by which a file-oriented system stores and managesdata.Today, file processing is less common than database systems, although in somecases, file processing is more efficient and cost-effective. Database systems provide aframework for storing data within a real-time, dynamic environment, without the risk ofdata redundancy. A database management system (DBMS) is a collection of tools,features, and interfaces that allows users to manage the contents of a database.
Link: https://www.coursehero.com/file/7367193/CH9doc/?justUnlocked=1

2. What is a DBMS? Briefly describe the components of a DBMS.
Answer: DBMS stands for Database Management System. A DBMS is a collection of tools,features, and interfaces that enable users to add, update, manage, access, and analyze thecontents of a database. A DBMS provides an interface between a database and the users,database administrators (DBAs), and the other information systems with which theDBMS interacts. In addition to interfaces, other DBMS components include a datamanipulation language, a schema, and a physical data repository. A data manipulationlanguage, or DML, controls the operations of the database.
Link: https://www.coursehero.com/file/7367193/CH9doc/?justUnlocked=1

3. Describe a primary key, candidate key, secondary key, foreign key, and a common field.
Answer: A primary key is a field or a combination of fields that uniquely identifies a particular member of an identity.
(
A candidate key field refers to any field that could serve as a primary key.
(
A secondary key, which is a non-unique field or combination of fields that can be