1 / 13

Database Management Systems

Database Management Systems. Chapter 1 Introduction. DBMS: Database Management System. Database A collection of data stored in a standardized format, designed to be shared by multiple users. Database Management System

majed
Download Presentation

Database Management Systems

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 Chapter 1 Introduction Database Management Systems - Jerry Post

  2. DBMS: Database Management System • Database • A collection of data stored in a standardized format, designed to be shared by multiple users. • Database Management System • Software that defines a database, stores the data, supports a query language, produces reports, and creates data entry screens. Database Management Systems - Jerry Post

  3. Application Development Feasibility Identify scope, costs, and schedule Analysis Gather information from users tasks Design Define tables, relationships, forms, reports Development Create forms, reports, and help; test Implementation Transfer data, install, train, review time Database Management Systems - Jerry Post

  4. DBMS Query Processor All Data Database Engine Data Dictionary Query Processor Animal AnimalID Name Category Breed Database Management Systems - Jerry Post

  5. DBMS Report Writer All Data Database Engine Data Dictionary Query Processor Report Writer Report Format and Query Database Management Systems - Jerry Post

  6. DBMS Input Forms All Data Database Engine Data Dictionary Query Processor Form Builder Input Form Design Database Management Systems - Jerry Post

  7. Advantages of Database Approach • Minimal data redundancy. • Data consistency. • Integration of data. • Sharing of data. • Enforcement of standards. • Ease of application development. • Uniform security, privacy and integrity. • Data independence. Database Management Systems - Jerry Post

  8. Examples of Commercial Systems • Oracle • Informix (Unix) • DB2, SQL/DS (IBM) • Access (Microsoft) • SQL Server (Microsoft +) • Many older (Focus, IMS, ...) • mySQL • ProgresSQL Database Management Systems - Jerry Post

  9. Hierarchical Database Customers Customer Order Items Ordered Orders To retrieve data, you must start at the top (customer). When you retrieve a customer, you retrieve all nested data. Items Item Description Quantity 998 Dog Food 12 764 Cat Food 11 Database Management Systems - Jerry Post

  10. Network Database Entry point Customer Order Items Ordered Items Entry point Database Management Systems - Jerry Post

  11. Relational Database Customer(CustomerID, Name, … Order(OrderID, CustomerID, OrderDate, … ItemsOrdered(OrderID, ItemID, Quantity, … Items(ItemID, Description, Price, … Database Management Systems - Jerry Post

  12. Government Customer Commercial Customer ContactName ContactPhone Discount, … ContactName ContactPhone … NewContact NewContact Object-Oriented DBMS Order Customer OrderID CustomerID … CustomerID Name … NewOrder DeleteOrder … Add Customer Drop Customer Change Address OrderItem Item OrderID ItemID … ItemID Description … OrderItem DropOrderItem … New Item Sell Item Buy Item … Database Management Systems - Jerry Post

  13. Separate inherited classes. Link by primary key. Adding a new customer requires new rows in each table. Definitely need cascade delete. Objects in a Relational Database Customer CustomerID Address Phone CommercialCustomer GovernmentCustomer CustomerID Contact VolumeDiscount CustomerID Contact BalanceDue Database Management Systems - Jerry Post

More Related