Introduction to Database Management Systems

Planning = Writing programs, building databases, testing, installing, training, and documenting Analysis = Preliminary understanding of business situation, and conceptual data modeling Design = Thorough analysis of business situation, leading to functional requirements Implementation = Logical and physical database design, to develop technology and organization

SDLC = Cursory attempt at conceptual data modeling Prototyping = Time-consuming, but comprehensive

Business analysts = oversee the projects, manage the personnel Database analysts = analyze business situation and establish requirements Project managers = ensure data integrity and consistency Systems analysts = have technical expertise for overall information systems

<p>Planning = Functional requirements Analysis = Enterprise model and conceptual data modeling Design = Detailed conceptual data modeling Implementation = Logical and physical database design</p> Signup and view all the answers

<p>Users = coders of the programs that interact with the database Programmers = communicate their needs to analysts Data administrators = establish standards for data in business units Database architects = responsible for existing databases</p> Signup and view all the answers

<p>Monitoring, repairing, and enhancing = Planning Writing programs, building databases, testing, installing, training, and documenting = Design Preliminary understanding of business situation, and conceptual data modeling = Implementation Logical and physical database design, to develop technology and organization = Maintenance</p> Signup and view all the answers

<p>Need for program-data independence = ease of data access for less technical personnel Desire to manage more complex data types and structures = reduce maintenance Ease of data access for less technical personnel = manage more complex data types and structures Need for more powerful decision support platforms = need for program-data independence</p> Signup and view all the answers

<p>Data modelers = focus on database Other technical experts = analyze business situation and establish requirements Database analysts = network, operating system, documentation, etc. Systems analysts = establish standards for data in business units</p> Signup and view all the answers

<p>SDLC = Rapid development cycle Prototyping = Rapid development cycle</p> Signup and view all the answers

<p>Database architects = ensure data integrity and consistency Data administrators = coders of the programs that interact with the database Programmers = establish standards for data in business units Project managers = analyze business situation and establish requirements</p> Signup and view all the answers

<p>Planning = Thorough analysis of business situation, leading to functional requirements Analysis = Preliminary understanding of business situation, and conceptual data modeling Design = Monitoring, repairing, and enhancing Maintenance = Logical and physical database design, to develop technology and organization</p> Signup and view all the answers

<p>Desire to manage more complex data types and structures = need for more powerful decision support platforms Need for program-data independence = manage more complex data types and structures Need for more powerful decision support platforms = reduce maintenance Ease of data access for less technical personnel = need for program-data independence</p> Signup and view all the answers

<p>Enterprise Data Model = High-level entities and relationships for the organization Project Data Model = A detailed view, matching data structure in database or data warehouse Graphical Diagram = Capturing nature and relationship of data Relational Databases = Database technology involving tables and keys</p> Signup and view all the answers

<p>Entities = Noun form describing a person, place, object, event, or concept Attributes = Composed of relationships Relationships = Between entities, usually one-to-many or many-to-many Primary/Foreign Keys = Representing data structure in database or data warehouse</p> Signup and view all the answers

<p>Segment of an Enterprise Data Model = More detailed view of entities and relationships Segment of a Project Data Model = High-level view of entities and relationships Relational Databases = Database technology involving tables and relationships Graphical Diagram = Capturing detailed nature of data</p> Signup and view all the answers

<p>One-to-One (1:1) = Relationships between entities, usually one-to-many or many-to-many One-to-Many (1: N) = Relationship between entities, one entity to multiple entities Many-to-Many (M: N) = Relationship between entities, multiple entities to multiple entities Primary/Foreign Keys = Relationship between entities, one entity to one entity</p> Signup and view all the answers

<p>Graphical Diagram = Capturing nature and relationship of data for a project Enterprise Data Model = High-level entities and relationships for the organization Project Data Model = Capturing detailed nature and relationship of data for the organization Relational Databases = Database technology for capturing data relationships</p> Signup and view all the answers

<p>Attributes = Noun form describing a person, place, object, event, or concept Entities = Composed of attributes and relationships Relationships = Capturing nature and relationship of data Primary/Foreign Keys = Between entities, usually one-to-many or many-to-many</p> Signup and view all the answers

<p>Personal Databases = Megabytes Departmental Databases = Gigabytes Enterprise Applications = Terabytes or Petabytes Client/Server Databases = Kilobytes</p> Signup and view all the answers

<p>Personal Databases = One user Departmental Databases = Several users, usually doesn’t exceed 100 Enterprise Applications = Company-wide, very large user base Client/Server Databases = Department-wide</p> Signup and view all the answers

<p>Multi-Tiered Client/Server Database Architecture = Figure 1-12 Database Technologies = Figure 1-11 Personal Databases = Figure 1-10 Enterprise Applications = Figure 1-13</p> Signup and view all the answers

<p>Departmental Databases = Intended for several users, usually doesn’t exceed 100 Enterprise Applications = Typical size in the gigabytes, terabytes, or even petabytes Personal Databases = Typical size in the megabytes Client/Server Databases = Intended for one user</p> Signup and view all the answers

<p>Personal Databases = Single user, local scope Departmental Databases = Department-wide scope Enterprise Applications = Company-wide scope Client/Server Databases = Global scope</p> Signup and view all the answers

<p>Personal Databases = Simple Departmental Databases = Moderate Enterprise Applications = Complex Multi-Tiered Client/Server Database Architecture = Basic</p> Signup and view all the answers

<p>Enterprise Systems = Maintain historical data Data Warehouses = Integrates data from multiple data sources Data Lakes = Backbone of an organization ERP = Large integrated repository for internal and external data</p> Signup and view all the answers

<p>Data Warehouses = Large integrated repository for internal and external data Data Lakes = Integrates data from multiple data sources and maintain historical data ERP = Typically involve relational databases Supply Chain Management = Help identify patterns and trends</p> Signup and view all the answers

<p>Executive Dashboard = Database Evolution at Pine Valley Furniture Company Customer Relationship Management = An Example of an Executive Dashboard Project Planning = Courtesy Tableau Software Human Resource Management = Pine Valley Furniture Company</p> Signup and view all the answers

<p>Database Evolution = Chapter 1 Designing the Database = Chapter 2 Administering the Database = Chapter 1 Future of Databases = Chapter 3</p> Signup and view all the answers

<p>Figure 1-13 = An Example of an Executive Dashboard Figure 1-1 = Pine Valley Furniture Company Figure 1-2 = Database Evolution at Pine Valley Furniture Company Figure 1-14 = Courtesy Tableau Software</p> Signup and view all the answers

<p>ERP = Electronic Resource Planning PVF = Pine Valley Furniture Company SQL = Server Query Language CRM = Customer Relationship Management</p> Signup and view all the answers