Download - ISQS Website Management System
![Page 1: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/1.jpg)
KRISTA BROWNJULIA HENSLEY
SY LEEJEFF MORRIS
DERREK PORTERBRIAN WILDER
ISQS Website Management System
![Page 2: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/2.jpg)
Introduction
BRIAN WILDER
![Page 3: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/3.jpg)
Class Diagram
BRIAN WILDER
![Page 4: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/4.jpg)
![Page 5: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/5.jpg)
Use Case Narratives and Diagrams
JULIA HENSLEY
![Page 6: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/6.jpg)
Use Case Narratives
![Page 7: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/7.jpg)
Use Case Diagram: User
![Page 8: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/8.jpg)
Use Case Diagram: Administrator
![Page 9: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/9.jpg)
KRISTA BROWN
CRC Cards and Database Design
![Page 10: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/10.jpg)
CRC Cards
![Page 11: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/11.jpg)
Database Design
Attribute (Field) Data Type Null (Yes or No) Indexid Integer (4 Bytes) No Yes (Primary)Classification_id Integer (4 Bytes) No Yes (Foreign)First_name Varchar(45) No NoLast_name Varchar(45) No Notitle Varchar(4) No Nooffice Varchar(3) Yes Noemail Varchar(45) No Yesphone Varchar(45) No Yeswebsite Varchar(45) Yes Yes
![Page 12: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/12.jpg)
SY LEE
Database Size Calculations
![Page 13: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/13.jpg)
Table Attributes Calculations Total
Name Key Length # Keys # Records blocking factor # of Pages Base Storage
Requirements Storage for Keys Bytes Megabytes
admissions 309 1 40 0.301757813 132.56 135,737.99 54,295.20 309,544.04 0.295204204
admissions_levels 8 2 80 0.0078125 10,240.00 10,485,760.00 8,388,608.00 30,744,356.62 29.32010328
advisors 8 2 8 0.0078125 1,024.00 1,048,576.00 838,860.80 3,074,435.66 2.932010328
categories 413 2 50 0.403320313 123.97 126,946.25 101,557.00 372,207.71 0.354964931
categories_courses 8 2 100 0.0078125 12,800.00 13,107,200.00 10,485,760.00 38,430,445.77 36.6501291
classifications 49 1 4 0.047851563 83.59 85,598.04 34,239.22 195,202.26 0.186159386
courses 139 1 100 0.135742188 736.69 754,371.22 301,748.49 1,720,307.72 1.640613293
curriculums 354 2 8 0.345703125 23.14 23,696.63 18,957.31 69,478.77 0.06626012
degrees 63 2 4 0.061523438 65.02 66,576.25 53,261.00 195,202.26 0.186159386
descriptions 313 2 40 0.305664063 130.86 134,003.32 107,202.66 392,899.13 0.374697806
levels 53 1 3 0.051757813 57.96 59,353.36 23,741.34 135,352.51 0.129082216
people 240 2 100 0.234375 426.67 436,906.67 349,525.33 1,281,014.86 1.22167097
programs 313 2 8 0.305664063 26.17 26,800.66 21,440.53 78,579.83 0.074939561
Total Calculations 76,999,027.15 73.43199459
We project the database size to be around 75 megabytes
![Page 14: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/14.jpg)
DERREK PORTER
Storyboard
![Page 15: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/15.jpg)
Storyboard: User
![Page 16: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/16.jpg)
Storyboard: Administrator
![Page 17: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/17.jpg)
JEFF MORRIS
Application Overview
![Page 18: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/18.jpg)
Implementation
CakePHPMySQLApache
![Page 19: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/19.jpg)
MVC Overview
![Page 20: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/20.jpg)
MVC Overview
![Page 21: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/21.jpg)
MVC Overview
![Page 22: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/22.jpg)
MVC Overview
![Page 23: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/23.jpg)
MVC Overview
![Page 24: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/24.jpg)
MVC Overview
![Page 25: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/25.jpg)
MVC Overview
![Page 26: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/26.jpg)
MVC Overview
![Page 27: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/27.jpg)
MVC Overview
![Page 28: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/28.jpg)
MVC Overview
![Page 29: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/29.jpg)
MVC Overview
![Page 30: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/30.jpg)
Demonstration
http://jpmorrisco.com/school/isqs/dev/adminhttp://jpmorrisco.com/school/isqs/dev/
![Page 31: ISQS Website Management System](https://reader035.vdocuments.us/reader035/viewer/2022062502/56816923550346895de055ea/html5/thumbnails/31.jpg)
BRIAN WILDER
Conclusion