1 / 13

Database Management: Understanding Data and Information Concepts

Explore the differences between data and information, transactional and analytical databases, components of an information infrastructure, and ERD creation for a movie rental scenario. Learn how to convert ERD into tables and query a pet database.

gerodi
Download Presentation

Database Management: Understanding Data and Information Concepts

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Review Session • What is data, what is information, and give a real world example to differentiate these two concepts.

  2. Data versus information

  3. What is the main differences between a transactional database and an analytical database?

  4. Two types of data

  5. Components of an information infrastructure This is what is commonly thought of as “database management” This is the foundation for business intelligence

  6. Comparing Operational and Analytical Data Stores

  7. Prepare an ERD for the following scenario Renting a movie at Blockbuster: • Each movie is described by an ID, name, genre (horror, comedy, drama, romantic, and foreign) • A movie can be rented by one or many customers. • A customer is described by an ID, name, address, credit card number.

  8. Be sure • Identify primary keys • Attribute of relationship • Attribute is conceptual and abstract • Don not overcomplicate the problem

  9. Describe the relationship in this ERD and convert into tables FacultyID First name Faculty Last Name Teaches Semester Course Number Course Course name

  10. Converting that ERD into a schema

  11. The Rules 1. Create a table for every entity 2. Create table fields for every entity’s attributes 3. Implement relationships between the tables

  12. Query this database (petdb) How much does “Fluffy” weigh? What is the average weight of a cat? What is the name of the owner of “Snuggles”?

  13. List all the animal’s names SELECT name FROM petdb.pet; 2) What is the average weight of a cat? SELECT AVG(pet.weight) FROM petdb.pet WHERE pet.type= ‘Cat’ 3) What commands do you need to get pet’s name and owner location (4) What is the average weight for different categories of animals?

More Related