Database Final Exam 2023 with 100% correct answers

Database Structure that can store information about different categories of information and relationship between those categories of information. Database Management System (DBMS) A software system designed to store, manage and facilitate access to databases. Entity A person, place, object, event or idea for which we intend to collect data. Attribute (field or column) Characteristic or property of an entity ( ex. customer may have a name, address, phone number etc.) Relationships An association between entities: - one to many - many to many - one to one One-to-Many Relationship Each rep is associated with many customers and each customer is associated with a single rep (1:M) Many-to-Many Relationship An employee learns many skills and a skill can be learned by many employees (M:N) One-to-One Relationship An employee manages a single store and a store is managed by a single employee (1:1) Datafile File used to store data (computer counterpart to ordinary paper file). Hierarchical Database Model Data is organized as an inverted tree. Each entity has only one parent but can have several children. At the top of the hierarchy there is one entity called the root. Network Database Model Entities are organized in a graph, in which some entities can be accessed through several paths. Relational Database Model Data is organized in 2- dimensional tables called relations (the tables or relations are related to each other). Entity-Relationship Diagram (ERD) Visual way to represent a database (rectangles represent entities and lines represent relationships between connected entities).