Lovely Professional University 2011 B.Tech Computer Science and Engineering Database management system-assignment 2 - exam paper

PART – A

1. Design an ER diagram for an IT training group database that will meet the info needs for its training program. Clearly indicate the entities, relationships and the key constraints. The description of the environment is as follows:

The company has 12 instructors and can handle upto 100 trainees for every training session. The company offers five Advanced technology courses, every of which is taught by a team of two or more instructors every instructor is assigned to a maximum of 2 teaching teams or may be assigned to do research every trainee undertakes 1 Advanced technology course per training session.
ANS: [with the attachment]

2. Identify at lowest five DBMS successfully running in market and compare their features.

ANS:
1. IBM's DB2- The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on UNIX (namely AIX), Linux, IBM i, z/OS and Windows servers. DB2 also powers the various IBM InfoSphere Warehouse editions. Alongside DB2 is a different RDBMS: Informix, which was acquired by IBM in 2001. DB2 also lets you store a few parts of your code at the server instead of keeping all of it in your client application. This can have performance and maintenance benefits.
There are features to protect data and to describe relationships ranging from data. As well, there are object-relational features to create flexible, advanced applications. You can use a few features in more than 1 way. For example, constraints enable you to protect data and to describe relationships ranging from data values. Here are a few key DB2 features:
• Constraints
• User-defined kinds (UDTs) and large objects (LOBs)
• User-defined functions (UDFs)
• Triggers
• Stored procedures

2. Oracle- The Oracle Database is an object-relational database management system(ORDBMS) produced and marketed by Oracle Corporation.
Larry Ellison and his friends and former co-workers Bob Miner and Ed Oates started the consultancy Software Development Laboratories (SDL) in 1977. SDL developed the original version of the Oracle software. The name Oracle comes from the code-name of a CIA-funded project Ellison had worked on while previously employed by Ampex.
• Scalability and Performance
• Manageability
• Backup and Recovery
• High availability
• Business Intelligence
• Content Management
• Security
• Data integrity/Triggers
• Information Integration Features

3. Microsoft SQL Server- Microsoft SQL Server is a relational model database server produced by Microsoft. Its primary query languages are T-SQL and ANSI SQL.
• Database Mirroring
• Online Restore
• Online Indexing Operations
• Fast Recovery
• Standards-based info Access SQL
• Server Management Studio
• Dedicated Administrator Connection


4. PostgreSQL- PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.

Earning:   Approval pending.