Team TBD Member 1 Member 2 Member 3
Team #TBD Member 1, Member 2, Member 3, Member 4 [Alphabetical] DBMS Prototype [12+ Diagram Content Slides, Intro, Roadmap, Summary – Move Irrelevant Slides to Backup Section] November 4, 2015 Embry Riddle Prescott
Presentation Roadmap System Block Diagram Capability Requirements Information Model and Functional Design (Block Diagram, My. SQL Workbench, Modelio, Visio Stencils, UML Stencils, MS Software Design Stencils, or Basic Drawing Tools in Power. Point) 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 Embry Riddle Prescott https: //www. mysql. com/products/workbench/ https: //www. modelio. org/ CASE TOOLS USED: My. SQL Workbench, Modelio, Other? System Models • Block Diagram Information Model and Functional Design • ER/EER • Referential Integrity Features • Normalized Tables (3 NF, BCNF) • Transactions Shown on ER/EER • User Views Required (Planned) Schema Design and Test • My. SQL 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) 2
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 I/O label Software System Service, Task, Process, etc. I/O label Hardware or Other System External Entity I/O label End Users I/O label Cloud Service Embry Riddle Prescott System Administration 3
Capability Requirements 1. Capability #1 2. Capability #2 3. Capability #3 4. Capability #4 Embry Riddle Prescott 4
ER/EER Diagram My. SQL Workbench CASE Diagram Or Power. Point ER/EER Diagram Or Modelio UML Embry Riddle Prescott 5
ER/EER or WB Schema Walk-through 1. Entities (or Classes) 2. Relationships Between Them 3. My. SQL Workbench Schema Capture 4. SQL Command Line [Show Tables, Describe, etc. ] Embry Riddle Prescott 6
Logical Design #1 1. Normalized Tables (Level) Embry Riddle Prescott 7
Logical Design #2 1. Transactions Embry Riddle Prescott 8
Logical Design #3 1. User View Design Embry Riddle Prescott 9
Physical Design #1 1. Storage Media Choice (Memory, File System, Block Storage Partition) 2. Indexing Scheme (My. ISAM, Inno. DB, Other? ) 3. Planned Storage Security and Protection (RAID, Client Connection, Privileges, etc. ) Embry Riddle Prescott 10
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
Schema Data Population Tests DML to Load Test Data Browse on Adminer Example SQL Multi-Table Queries (Transactions) Embry Riddle Prescott 12
Proof-of-Concept ANALYSIS Demonstration of Major User Views Demonstration of Client Applications Using Secure Connector General Use Demonstrations Embry Riddle Prescott 13
Summary Thank Audience Encourage Submission of Deficiency Sheets Open to Q&A for 10 Minutes Sam Siewert 14
Backup Slides Move Slides Not Making MUST PRESENT Status to HERE for Q&A Embry Riddle Prescott 15
- Slides: 15