1 / 15

Team #TBD Member1, Member2, Member3, Member4 [Alphabetical]

This presentation showcases the prototype for a database management system (DBMS) that includes system block diagram, capability requirements, information model and functional design, ER/EER relationships, referential integrity features, logical and physical design, schema design and test, and proof-of-concept analysis.

jmonahan
Download Presentation

Team #TBD Member1, Member2, Member3, Member4 [Alphabetical]

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. Team #TBDMember1, Member2, Member3, Member4 [Alphabetical] DBMS Prototype [12+ Diagram Content Slides, Intro, Roadmap, Summary – Move Irrelevant Slides to Backup Section]  Embry Riddle Prescott

  2. Presentation Roadmap • System Block Diagram • Capability Requirements • Information Model and Functional Design (Block Diagram, MySQL Workbench, Modelio, VisioStencils, UML Stencils, MS Software Design Stencils, or Basic Drawing Tools in PowerPoint) • Data Referential Integrity, Normalization, Transactions and User Views • ER/EER Relationships • Referential Integrity Features (Triggers, Domain Typing, NULL not allowed, etc.) • Logical Design Normalization • Transaction Design for Clients • User Views Required • Performance [Indexing and Storage Media] • Schema Design and Test • Schema Walkthrough • Forward Engineering (Deployment) • DML to Load Test Data • Proof-of-Concept Data Population and Tests https://www.mysql.com/products/workbench/ https://www.modelio.org/ CASE TOOLS USED: MySQL Workbench, Modelio, Other? • System Models • Block Diagram • Information Model and Functional Design • ER/EER • Referential Integrity Features • Normalized Tables (3NF, BCNF) • Transactions Shown on ER/EER • User Views Required (Planned) • Schema Design and Test • MySQL Workbench Schema • Forward Engineering and Browse on Adminer • DML Test Data Load, Browse, Query • Proof-of-Concept • Demo of Client Views (Transactions) • Demo of Connector Application(s)  Embry Riddle Prescott 2

  3. System Block Diagram – Content #1 • Any Useful Information about System • Keep it Simple – One Page View of Everything • Users, IT, Software, External Systems and Hardware Hardware or Other System External Entity Software System Service, Task, Process, etc. I/O label I/O label I/O label End Users I/O label Cloud Service System Administration  Embry Riddle Prescott 3

  4. Capability Requirements • Capability #1 • Capability #2 • Capability #3 • Capability #4  Embry Riddle Prescott 4

  5. ER/EER Diagram • MySQL Workbench CASE Diagram • Or PowerPoint ER/EER Diagram • Or Modelio UML  Embry Riddle Prescott 5

  6. ER/EER or WB Schema Walk-through • Entities (or Classes) • Relationships Between Them • MySQL Workbench Schema Capture • SQL Command Line [Show Tables, Describe, etc.]  Embry Riddle Prescott 6

  7. Logical Design #1 • Normalized Tables (Level)  Embry Riddle Prescott 7

  8. Logical Design #2 • Transactions  Embry Riddle Prescott 8

  9. Logical Design #3 • User View Design  Embry Riddle Prescott 9

  10. Physical Design #1 • Storage Media Choice (Memory, File System, Block Storage Partition) • Indexing Scheme (MyISAM, InnoDB, Other?) • Planned Storage Security and Protection (RAID, Client Connection, Privileges, etc.)  Embry Riddle Prescott 10

  11. Schema Design and Test • SQL DDL or Workbench Schema Deployment to PRClab • Demonstration • Browse with Adminer and/or Show Tables, Describe  Embry Riddle Prescott 11

  12. Schema Data Population Tests • DML to Load Test Data • Browse on Adminer • Example SQL Multi-Table Queries (Transactions)  Embry Riddle Prescott 12

  13. Proof-of-Concept ANALYSIS • Demonstration of Major User Views • Demonstration of Client Applications Using Secure Connector • General Use Demonstrations  Embry Riddle Prescott 13

  14. Summary • Thank Audience • Encourage Submission of Deficiency Sheets • Open to Q&A for 10 Minutes  Sam Siewert 14

  15. Backup Slides Move Slides Not Making MUST PRESENT Status to HERE for Q&A  Embry Riddle Prescott 15

More Related