1 / 17

Understanding Relational Databases

Understanding Relational Databases. MS Access 2007. Understanding Relational Databases. Choosing between Excel and Access Relational database concepts Relational Database Management System Getting started with MS Access 2007 Demos.

haileyn
Télécharger la présentation

Understanding Relational Databases

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. Understanding Relational Databases MS Access 2007 IT User Services - University of Delaware

  2. Understanding Relational Databases • Choosing between Excel and Access • Relational database concepts • Relational Database Management System • Getting started with MS Access 2007 • Demos IT User Services - University of Delaware

  3. Choosing between Excel and AccessBoth organize data in columns and rows – guidelines for selecting one over the other IT User Services - University of Delaware

  4. Choosing between Excel and AccessBoth organize data in columns and rows – guidelines for selecting one over the other IT User Services - University of Delaware

  5. Choosing between Excel and AccessBoth organize data in columns and rows – guidelines for selecting one over the other IT User Services - University of Delaware

  6. Choosing between Excel and Access Guidelines for selecting one over the other IT User Services - University of Delaware

  7. Relational database concepts • Database: Organized collection of data • Purpose: Store , modify, and retrieve data. • Database table: Holds and organizes the data. • Rows (records) for each uniquedata instance; uniqueness provided by primary key. Examples: • Check #, date, amount, payee (check register) • Student ID, first and last names, address, phone # (student records) • Columns (fields) for each type of data. Examples: • Amounts • Last names IT User Services - University of Delaware

  8. Relational database concepts • Flat file database: Single table (looks similar to Excel spreadsheet.) • Relational database: Two or more tables with a defined relationship between or among them • Relationships between tables are defined by physical or business rules. • Primary key in one table relates to equivalent column in another table (foreign key). IT User Services - University of Delaware

  9. Relational database concepts • Relationship types: one-to-one • E.g.: Information about states and state capitals IT User Services - University of Delaware

  10. Relational database concepts • Relationship types: one-to-many • E.g.: Database for tracking student financial transactions IT User Services - University of Delaware

  11. Relational database concepts • Relationship types: many-to-many • E.g.: University student judicial database (students involved in events leading to judicial hearings) • Requires “bridging” or “linking” table in the database. IT User Services - University of Delaware

  12. Relational database concepts • Relational Database Management System • Contains related tables for storing data and tools and interfaces for data manipulation. For example: • Relationship management tools • Forms (data entry) • Mechanism to enforce design rules • Queries (data retrieval) • Reporting tools • Programming environment IT User Services - University of Delaware

  13. Relational database concepts • Relational Database Management System • MS Access provides all the tools listed below. In other database management systems the tools may have to be licensed or purchased separately (e.g., forms and reports for Oracle or SQL Server) • Relationship management tools • Forms (data entry) • Mechanism to enforce design rules • Queries (data retrieval) • Reporting tools • Programming environment IT User Services - University of Delaware

  14. MS Access is a relational database management system. It is a file-based system, not a client-server system (like Oracle or SQL Server), and is not ideal for data sharing across large work groups. IT User Services - University of Delaware

  15. Get started with MS Access 2007(demos) • Create a new database • Create tables and enter data • Copy and paste • Import or link from other data source • Enter data by hand • Data entry form (preferred) • Directly into table (not recommended) • Use an existing database IT User Services - University of Delaware

  16. For more information IT User Services - University of Delaware • Microsoft Office Online • Access 2007 courses (short video/audio/text) • http://office.microsoft.com/en-us/access/CH100739911033.aspx • Access 2007 demos • http://office.microsoft.com/en-us/access/CH100739911033.aspx • Access 2007 help (same as Help in the program) • http://office.microsoft.com/en-us/access/FX100646911033.aspx?CTT=96&Origin=CL100570041033 • Access tips (beginner, advanced, 2007-specific) • http://www.allenbrowne.com/tips.html

  17. Thank you for coming! IT User Services - University of Delaware

More Related