IT 204 Milestone 4 - IT 204 Milestone Four Page |1 IT 204 Milestone Four Data and Info Management Southern New Hampshire University April 4 2017 IT

IT 204 Milestone 4 - IT 204 Milestone Four Page |1 IT...

This preview shows page 1 - 3 out of 3 pages.

I T 2 0 4 : M i l e s t o n e F o u rP a g e | 1IT 204: Milestone FourData and Info Management Southern New Hampshire University April 4, 2017
I T 2 0 4 : M i l e s t o n e F o u rP a g e | 2Group C: DBMS Assignment – MySQLSpecification CategorySpecification/Comments1.Data Size LimitsWhile a table in MySQL can be incredibly large (Maximum is currently up to 65,536 TB.) The larger the table, the slower it may run and the more equipment you would need to run the larger database. While table rows can be defined in MySQL, there is a hard limit of 4096 columns, different database types might have different limits as well depending on how it is created. 2.Purchase CostBetween $700 - $1,500 on desktop computers, or laptops for staff.Hiring, and or Training of Employee(s) to handle the DBMS. Software, and Software Maintenance.Total cost about $5k per year.3.AdministrationWith a correctly trained administrator, MySQL is one of the more simple database to create, put into place and maintain compared to other database systems. It would be of the school’s best interest to hire

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture