Chapter 1 - Database Management Systems Graded A+

Chapter 1 - Database Management Systems Graded A+ What is an entity? ️ A person, place, object, event, or idea for which you want to store information. What is an attribute? ️ A characteristic or property of an entity. What is a column or a field? ️ Another name for an attribute. What is a Database Design? ️ The process of determining the content and structure of data in a database in order to support some activity on behalf of a user or group of users. What is a database? ️ A structure that can store information about multiple types of entities, the attributes of those entities, and the relationships between the entities. What is an Entity-relationship (E-R) diagram? ️ A visual way to represent a database. Rectangles represent entities, and lines represent relationships between connected entities. What is redundancy? ️ The duplication of data or the storing of the same data in more than one place. What is a relationship? ️ An association between entities. What is a one-to-many relationship? ️ The first entity is associated with all of the occurrences of the second entity, but the second entity is associated with only one of the occurrences of the first entity. What are the problems associated with redundancy? ️ Difficulty accessing related data, limited security, size limitations, changes are cumbersome and time-consuming, waste of space, and leads to inconsistencies. What is a data file? ️ A file that is used to store data and the computer counterpart to an ordinary paper file. Spreadsheets, word-processed documents, and web pages are examples of it. What is a Database Management System (DBMS)? ️ A program, or collection of programs, through which users interact with a database. Access, Oracle, DB2, MySQL, and SQL Server are examples of it. What are Forms? ️ Screen objects used to maintain, view, and print data from a database. What are Reports? ️ DBMS asks questions about the desired content and appearance of each report, then creates it automatically based on the answers. What is a primary key? ️ A minimal collection of columns (attributes) in a table on which all columns are functionally dependent and that is chosen as the main direct-access vehicle to individual rows. What is a record? ️ A collection of related fields; can be thought of as a row in a table. What is Data Independence? ️ The property that lets you change the structure of a database without requiring you to change the programs that access the database; examples of these programs are the forms you use to interact with the database and the reports that provide information from the database. What is Database Administration? ️ The individual or group that is responsible for a database. What is a Database Administrator? ️ The individual who is responsible for a database, or the head of database administration. What is Integrity? ️ A database has integrity if the data in it satisfies all established integrity constraints. What is Integrity constraint? ️ A rule that must be followed by data in a database. What is Security? ️ The prevention of unauthorized access to a d