1 / 11

Database Management Systems II

Database Management Systems II. Session 5. Objectives. Design database schema Understand elements of RDBMS Understand use of SQL and read simple SQL commands Complete a RDBMS exercise using MS Access. Database Schema Queries, Forms and Reports Introduction to SQL Hands-on exercise.

clayton
Download Presentation

Database Management Systems II

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. Database Management Systems II Session 5

  2. Objectives • Design database schema • Understand elements of RDBMS • Understand use of SQL and read simple SQL commands • Complete a RDBMS exercise using MS Access

  3. Database Schema Queries, Forms and Reports Introduction to SQL Hands-on exercise Topics

  4. Scenario • Draw an E-R diagram: • Northwind is a wholesaler of delicatessen products. Customers are all over the world and each member of the sales team may deal with any customer. Products is kept in a central warehouse and items are ordered from Suppliers when numbers reach the re-order level. An Order may consist of several different products and may be delivered by any one of three Shippers.

  5. Entity-Relationship Diagram

  6. Table Definition

  7. RDBMS Objects FORMS TABLES QUERIES REPORTS

  8. Forms

  9. Reports

  10. SQL Code SELECT ProductID, ProductName FROM Products WHERE Discontinued = ‘No’ ORDER BY ProductName; - What will the query output look like? - What is this query doing?

  11. Exercise • Honest Pete’s Car Sales is a business that deals in second hand cars. You have been given a table of current stock and a table of sales staff. • Construct a schema with table definitions showing primary keys and indicating how tables should be linked. • Following your design, construct the DBMS in MS Access

More Related