Get fully solved assignment. Buy online from website
online store
or
plz drop a mail with your sub code
we will revert you within 2-3 hour or immediate
Charges rs
125/subject and rs 625/semester only.
if urgent then call us
on 08791490301, 08273413412
PROGRAM
BCA (REVISED 2012)
SEMESTER - 3
SUBJECT CODE &
NAME
BCA3020 - Database
Management System
BK ID - B1479
CREDIT - 4
MAXIMUM MARKS – 60
Q1. What is
Database? Explain its properties. 10
Answer:
Database: The database is a
collection of related data. The basic component of a file in a file
system is a data item, which is the smallest named unit of data that has
mSeaning in the real world – for example, last name, first name, street address,
ID number, or political party. A group of related data items
Q2. Write a note
on: 5+5
Ø
MySQL Architecture
Ø
Primary Subsystems
Answer:
MySQL Architecture: MySQL is based on a tiered
architecture, consisting of both primary subsystems and support
components, that interact with each other to read, parse, and execute
queries, and to cache and return query results. The MySQL architecture consists
of five primary subsystems that work
Q3. What are the
attributes used in the? Explain with the example of Student database. 10
Answer:
Attributes used in the E-R model: The
attribute used in the E-R model can be characterized by the following attribute
types.
·
Simple
Q4. What is
Relational Database Management System? Explain three aspects of RDBMS. 10
Answer:
Relational Database Management System: A Relational Database Management
System (RDBMS) provides a comprehensive and integrated approach to
information management. A relational model provides the basis for a
relational database. A relational model has three aspects:
Q5. What do you
mean by Embedded SQL? How do you declare variables and exceptions? 10
Answer:
Embedded SQL: We have looked at a wide range of
SQL query constructs, treating SQL as an independent language in its own
right. A relational DBMS supports an interactive SQL interface,
and users can directly enter SQL commands. This simple approach is fine as long
as the task at hand can be accomplished entirely with SQL commands. In
practice we often encounter situations in which we need
Q6. Briefly explain
the reasons behind Object-relational impedance mismatch. 10
Answer:
Object-relational impedance:
mismatch. This type of problem occurs when objects or class definitions are
mapped in a straightforward way to database tables or relational schema.
Object-relational impedance
mismatch is due to the
Get fully solved assignment. Buy online from website
online store
or
plz drop a mail with your sub code
we will revert you within 2-3 hour or immediate
Charges rs
125/subject and rs 625/semester only.
if urgent then call us
on 08791490301,
08273413412
No comments:
Post a Comment