Database Management

What are the features and advantages of relational databases and object-oriented databases? Relational databases are considered simplicity of underlying concepts and query languages.

Objective oriented databases: reduce the amount of programming needed and also permits the storage of complex data that is not easily accommodated by relational databases.

2. What are the fields, records, and tables in databases? Field: is a vertical column in a database. It contains data/ information that represent the same characteristics for all medical records. Record: is data that is presented in horizontal rows. These records contain different pieces of data belonging to a given enity (person). Tables: consists of all records combining the data in the fields and records in a table where it can make it possible to manipulate selected records or fields based on specific data elements in those fields.

3. What is an algorithm? What is Boolean Arithmetic? What is a data dictionary? Algorithm is when data can be organized by names and or addresses and these names can be sorted alphabetically by their last name. Boolean Arithmetic: provides the underlying logic for queries or searches when a database is being used to search a database. These values are expressed either as true or false. Data dictionary: is a table that provides information about a database. It is a table that contains a list of all the tables in that database.

4. Identify a specific health or health delivery problem, and list the steps in planning a database for the management of that problem. Begin with three questions that might be asked and the fields to be included.

• Team managers want to identify issues with keeping track of their employee’s yearly physicals.

• Field name- last name, first name, employee ID#, street address, city, state, zip code, home#, date of hire, physical, physical date, date of next physical, e-mail address.

• Required data by using relational databases such as tables,...