| Problems with the Current System Criteria Specification & Imposed Constraints A more Detailed Look at Proposed Alternatives Analysis of Proposed Alternative |
Analysis of Proposed Alternative SystemPlatform comparison SQL Server 2000 only works on Windows-based platforms, including Windows 9x, Windows NT, Windows 2000 and Windows CE. Microsoft Access 2000 can be installed under the following operating systems: Microsoft Windows 95, Windows 98, Windows 98 Second Edition, Windows Millennium Edition (Windows Me), Windows NT 4.0 with Service Pack 6 (SP6), Windows 2000, or Windows XP or later. Hardware requirements To install SQL Server 2000, the Intel or compatible platforms and the following hardware are required:
Table 1:
Hardware Requirements of SQL Server 2000
Microsoft Access 2000 is included in the Professional and Developer Editions of Microsoft Office 2000, but can be purchased separately, as well. If you install Access 2000 with other Office 2000 products, the hardware requirement can be increased in comparison with the single Access 2000 installation. To install Microsoft Access 2000, you should have the following hardware:
Table 2: Hardware Requirements
of Access 2000
Software requirements SQL Server 2000 comes in six editions:Enterprise, Standard, Personal, Developer, Desktop Engine and SQL Server CE (a compatible version for Windows CE) and requires the following software:
Table 3:
Software Requirements of SQL Server
In comparison with SQL Server 2000, Microsoft Access 2000 does not have any editions. Access 2000 can be installed under the following operation systems: Microsoft Windows 95, Windows 98, Windows 98 Second Edition, Windows Millennium Edition (Windows Me), Windows NT 4.0 with Service Pack 6 (SP6), Windows 2000, or Windows XP or later. Price comparison SQL Server 2000 is currently available under two licensing options:
The processor license requires a single license for each CPU in the computer running SQL Server 2000 and includes unlimited client access. You can buy this license when you do not know the number of the clients (for example, if your users will connect to SQL Server 2000 through the internet). This license usually is cheaper than Server/Per-Seat CAL when there are many users connected to SQL Server databases. The Server/per-seat client access license (CAL) requires a license for the server and the licenses for each client device. You can use this licensing option when the customers do not need access beyond the firewall and the number of clients is low (for example, 10-20 users for SQL Server 2000 Standard Edition or 30-40 users for SQL Server 2000 Enterprise Edition).
Table 4: SQL Server 2000 Standard Edition and Enterprise Edition Cost Comparison
Microsoft Access 2000 like Office 2000 is no longer available at retail for individual purchases. Microsoft Access 2002 and Office XP can be purchased now. The process of obtaining a previous version of a Microsoft product is called "downgrading." Downgrade rights apply to volume license customers only. This is the current price for Microsoft Access 2002. Because Access 2002 is included in the Professional and Developer Editions of Microsoft Office XP, the prices of the Office XP Professional Edition and Office XP Developer Edition are also included.
Table 5: Microsoft
Access 2002 Current Prices
Features comparison Microsoft Access 2000 falls into the desktop category and works best for individuals and workgroups managing megabytes of data. In comparison with SQL Server 2000, Access uses file-server architecture, rather than client-server architecture. Access 2000 has many restrictions in comparison with SQL Server 2000 and cannot be used in the case where you want to build a stable and efficient system with many concurrent users. Some SQL Server 2000 and Access 2000 restrictions:
Table 6: Comparison
of SQL Server 2000 and Access 2000 Features
SQL Server 2000 and Access 2000 limits
Table
7: Limits of SQL Server 2000 and Access 2000
|