Database management systems (DBMS)

Ace your homework & exams now with Quizwiz!

What are boo lean operators?

AND, OR, NOT for searching

What is a database management system?

a program controlling the structure of a database and access to the data; creates, processes, and administers database

What is access?

a relational database organized as a series of tables related through key fields

What are objects?

a table, forms, report, or query that can be created and manipulated as a unit by the user.

What is a database structure?

an arrangement of the fields, tables, and relationships

What is database planning?

an extremely important step in database creation process

Entities have..

attributes: describe characters identifier: attribute whose value is associated with one and only on entity

What are global updates?

based on some criteria

What are joining tables?

creating relationship

What is metadata?

data that describes data makes data more useful makes data easier to use

What are some things that go into selecting a DBMS?

database size number of concurrent users performance integration features vendor cost

What is a relational database design?

designer creates table for every entity entity identifier becomes primary key of table attributes of entity become columns tables normalize to single theme represent relationships between table

What are tables in an access database?

different groups of information -tables that are linked together to provide a related output

Database content?

entities stored in database and relationship among those things

What are some techniques for creating a data model?

entity relationship data model unified modeling language

What is a key field?

field that is used to uniquely identify a record

What is a primary key?

field that uniquely identifies each record

What is the most complex relationship?

many-to-many

More tables =

more flexible

Entities are always...

singular

What is a field in an access database?

smallest piece of information in a record, organized by a column

What is an attribute?

specific piece of data about an entry -fields

What are SQL keywords?

they issue instructions -create, delete, insert, etc.

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

How do you begin planning?

types of tables number of tables structure of tables types of inputs types of outputs

Are entities something that users want tracked?

yes

What are some advantages of a DBMS?

-reduced data redundancy -improved data integrity -more program independence -increased user productivity -increased security

.

.

What is a structured query language (SQL)?

SQL is an international standard language for manipulating relational databases

a key field..

allows for easier retrieval, analysis and manipulation of records

What do SQL queries consist of?

an action, database table name, set of parameters

What is a record in an access database?

row in a table with information about one person, client, or other entity

What is an entity?

item for which we want to store information -tables

Entities may be...

physical object logical construct transaction

What is an entity relationship diagram (ERD)?

picture of how data is related

What is a database design?

process of converting data model which transforms entities into tables and expresses relationships


Related study sets

Akinah's Principles of Macroeconomics

View Set

Chapter 24: Nutrition Practice Homework

View Set

ACC 202 Chapter 3 (Anderson SDSU)

View Set

Performance by Client needs PrepU

View Set

Operational amplifier fundamentals (Test 15)

View Set