Practical Database Design Methodology

The current relational DBMSs that dominate the market are Oracle, Microsoft SQL SERVER, and IBM DB2 etc. I am familiar with Microsoft SQL server and it measures up based on the following criteria Low cost for ownership of software The Microsoft SQL Server support various tools and upfront software cost at no additional price. It has backward compatibilitywith previous version of Microsoft SQL server version so there is not any requirement of updating each and every system. Highly secure The security system of Microsoft SQL Server is very strong as it has secure authentication process which uses better password management features. Software complexity The Microsoft SQL Server is very easy to use and data can manage easily by various database management tools. Cost of administration of SQL server over other software Here the cost of administration of SQL server is compared with Oracle. In SQL server, Database admin could manage over 65 database of SQL whereas in oracle, Database admin could manage over 15 databases. Oracle admin has higher salary over SQL server DBA so cost of administration of SQL server is less as compared to oracle. 10.23 - A possible DDL corresponding to Figure 3.1 is shown below CREATE