BT0066 - Database Management Systems

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id :

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601

(Prefer mailing. Call in emergency )

ASSIGNMENT

WINTER	2013
PROGRAM	BSc IT
SEMESTER	FIRST
SUBJECT CODE & NAME	BT0066, Database Management Systems
CREDIT	3
BK ID	B0950
MAX. MARKS	60

Note: Answer all questions. Kindly note that answers for 10 marks questions should be approximately of 400 words. Eachquestion is followed by evaluation scheme.

Q.1 what is DBMS? Why it is required?

Answer: A database management system is the software system that allows users to define, create and maintain a database and provides controlled access to the data.

A Database Management System (DBMS) is basically a collection of programs that enables users to store, modify, and extract information from a database as per the requirements. DBMS is an intermediate layer between programs and the data. Programs access the DBMS, which then accesses the data. There are different types of DBMS

Q.2Explain MySQL architecture with diagram.

Answer:MySQL's architecture consists of a web of interrelated function sets, which work together to fulfil the various needs of the database server. A number of authors3 have implied that these function sets are indeed components, or entirely encapsulated packages; however, there is little evidence in the source code that this is the case.

Indeed, the architecture includes separate function libraries, composed of functions that handle similar tasks, but there is not, in the traditional object-oriented programming sense, a full component-level separation of functionality. By this, we mean that

Q.3Differentiate between fixed and variable length records.

Answer:    In the Fixed Length record is set to a certain length and the location is simply calculated in the Variable Length Record the record size is irrelevant because all records are indexed sequentially in a header record.Variable length record is the record contain different format (length) but the first 4 bytes taking length of record. The fixed length record must be declaring length otherwise throw the error.so after fill the records md fields’fill up the filler clause.Fixed length means the length of all records in the file is

Same.so we code record length is x chrs

Q.4 Write an sql query to create the table named employee with the following attributes:

Employee number – not null

Employee name

Department id

Make employee number as primary key.

Answer: Employee Table (EMPLOYEE)

The employee table identifies all employees by an employee number and lists basic personnel information. The employee table is created with the following CREATE TABLE and ALTER TABLE statements:

Q.5  Explain First Normal form and Second Normal Form.

Answer: First normal form (1NF) is a property of a relation in a relational database. A relation is in first normal form if the domain of each attribute contains only atomic values, and the value of each attribute contains only a single value from that domain.Second normal form (2NF) is a normal form used in database normalization. 2NF was originally defined by E.F. Codd in 1971.

Q.6 what is object oriented database system? Explain.

Answer:An object-oriented database is a database that subscribes to a model with information represented by objects. Object-oriented databases are a niche offering in the relational database management system (RDBMS) field and are not as successful or well-known as mainstream database engines.

A system offering DBMS facilities in an object-oriented programming environment. Data is stored as objects and can be interpreted only using the methods specified by its class. The relationship between similar objects is preserved (inheritance) as are references between objects. Queries can be faster because joins are often not needed (as in a

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id :

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601

(Prefer mailing. Call in emergency )