Database management systems (DBMS)

Database management systems (DBMS) What is a database management system? ️ A program controlling the structure of a database and access to the data; creates, processes, and administers the database. What are some advantages of a DBMS? ️ - Reduced data redundancy - Improved data integrity - More program independence - Increased user productivity - Increased security What is DBMS used for? ️ To create tables and relationships in databases. What do applications use DBMS for? ️ To read, insert, modify, and delete data. What is a structured query language (SQL)? ️ SQL is an international standard language for manipulating relational databases. What do SQL queries consist of? ️ An action, database table name, set of parameters. What are SQL keywords? ️ They issue instructions - create, delete, insert, etc. What are boolean operators? ️ AND, OR, NOT for searching. What are global updates? ️ Based on some criteria. What are joining tables? ️ Creating relationships. What are some things that go into selecting a DBMS? ️ - Database size - Number of concurrent users - Performance - Integration - Features - Vendor - Cost What is a database structure? ️ An arrangement of the fields, tables, and relationships. What are some techniques for creating a data model? ️ - Entity relationship data model - Unified modeling language Database content? ️ Entities stored in the database and the relationship among those things. What is an entity? ️ An item for which we want to store information - tables. What is an attribute? ️ A specific piece of data about an entry - fields. What is an entity relationship diagram (ERD)? ️ A picture of how data is related. Are entities something that users want tracked? ️ Yes. Entities may be... ️ - Physical object - Logical construct - Transaction Entities are always... ️ Singular. Entities have... ️ Attributes: describe characters Identifier: attribute whose value is associated with one and only one entity. What is database design? ️ The process of converting data model which transforms entities into tables and expresses relationships. What is metadata? ️ Data that dDatabase management systems (DBMS) What is a database management system? ️ A program controlling the structure of a database and access to the data; creates, processes, and administers the database. What are some advantages of a DBMS? ️ - Reduced data redundancy - Improved data integrity - More program independence - Increased user productivity - Increased security What is DBMS used for? ️ To create tables and relationships in databases. What do applications use DBMS for? ️ To read, insert, modify, and delete data. What is a structured query language (SQL)? ️ SQL is an international standard language for manipulating relational databases. What do SQL queries consist of? ️ An action, database table name, set of parameters. What are SQL keywords? ️ They issue instructions - create, delete, insert, etc. What are boolean operators? ️ AND, OR, NOT for searching. What are global updates? ️ Based on some criteria. What are joining tables? ️ Creating relationships. What are some things that go into selecting a DBMS? ️ - Database size - Number of concurrent users - Performance - Integration - Features - Vendor - Cost What is a database structure? ️ An arrangement of the fields, tables, and relationships. What are some techniques for creating a data model? ️ - Entity relationship data model - Unified modeling language Database content? ️ Entities stored in the database and the relationship among those things. What is an entity? ️ An item for which we want to store information - tables. What is an attribute? ️ A specific piece of data about an entry - fields. What is an entity relationship diagram (ERD)? ️ A picture of how data is related. Are entities something that users want tracked? ️ Yes. Entities may be... ️ - Physical object - Logical construct - Transaction Entities are always... ️ Singular. Entities have... ️ Attributes: describe characters Identifier: attribute whose value is associated with one and only one entity. What is database design? ️ The process of converting data model which transforms entities into tables and expresses relationships. What is metadata? ️ Data that describes data; makes data more useful; makes data easier to use. What is the most complex relationship? ️ Mbes data; makes data more useful; makes data easier to use. What is the most complex relationship? ️ Many-to-many.