The latest version of ms access lets us store access

This preview shows page 3 - 5 out of 8 pages.

provides preparing and designing simple databases, data entry forms and reports. The latest version of MS Access lets us store, access and exchange data in XML format. It has ODBC capability to connect to other data sources and also capture data from other databases and excel sheets. MySQL MySQL is an open source RDBMS which is used with the combination of PHP and Apache Web Server, on top of a Linux distribution. MySQL also uses the SQL language to query the database. Analysis The top contenders of the RDBMS for the research database are MS Access and MS SQL Server. While both are Microsoft products, these have their own similarities and differences, strengths and weaknesses, especially in comparison with the needs of the organization. The need of the hospital is to create a database that stores all the necessary patient information resulting from their visits to the doctors where a research of a depression drug is being performed by the two supervisors with the help of 20 doctors and 400 patients. It is important that these doctors and supervisors have defined access rights to this database in order to understand the end-to-end data relating the tests and patients.
DBMS RESEARCH AND RECOMMENDATION 3 Similarities between MS Access and MS SQL Server Relational database management systems Microsoft products Differences between MS Access and MS SQL Server MS Access File based Uses Jet SQL Max file size 2GB Partitioning not available Not compliant to any SQL standard SQL Server Client/Server model Uses Transact-SQL Max database size 4GB Partitioning available Compliant to ANSI SQL standard. Strengths of MS Access Easy to install and use: A fully functional, relational DBMS can be installed in minutes which contains wizards that walk through each step of the way. Easy to integrate: It works well with many of the developing software programs based in Windows. .NET friendly: First choice for users who plan to develop software using .NET platform. Widely popular: The most popular desktop database system. Economical to use. Convenient storage capacity: An access database can hold up to 2 GB of data. Multi-user support: Can support up to 10 users in a network.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture