BT0066 - Database Management Systems
Dear students get fully solved assignmentsSend your semester & Specialization name to our mail id :[email protected] us at : 08263069601
Content
Dear students get fully solved assignments Send your semester & Specialization name to our mail id : “ [email protected] ” or Call us at : 08263069601 (Prefer mailing. Call in emergency )
ASSIGNMENT WINTER PROGRAM SEMESTER SUBJECT CODE & NAME CREDIT BK ID MAX. MARKS 2013 BSc IT FIRST BT0066, Database Management Systems 3 B0950 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 : “ [email protected] ” or Call us at : 08263069601 (Prefer mailing. Call in emergency )
ASSIGNMENT WINTER PROGRAM SEMESTER SUBJECT CODE & NAME CREDIT BK ID MAX. MARKS 2013 BSc IT FIRST BT0066, Database Management Systems 3 B0950 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 : “ [email protected] ” or Call us at : 08263069601 (Prefer mailing. Call in emergency )
