100%(7)7 out of 7 people found this document helpful
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.MySQLMySQL 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 querythe database. AnalysisThe top contenders of the RDBMS for the research database are MS Access and MS SQLServer. 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 RECOMMENDATION3Similarities between MS Access and MS SQL ServerRelational database management systemsMicrosoft productsDifferences between MS Access and MS SQL Server MS AccessFile basedUses Jet SQLMax file size 2GBPartitioning not availableNot compliant to any SQL standardSQL ServerClient/Server modelUses Transact-SQLMax database size 4GBPartitioning availableCompliant to ANSI SQL standard.Strengths of MS AccessEasy 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.