Mcs-023 Solved Assignment 2012-13 Upper

 

(Figure 2). New applications can be built and added to the current system and data notcurrently stored can be stored.

Data Independence

In the file-based system, the descriptions of data and logic for accessing the data are builtintoeach application program making the program more dependent on data. A change in thestructure of data may require alterations to programs. Database Management systemsseparates data descriptions from data. Hence it is not affected by changes. This is calledDataIndependence, where details of data are not exposed.DBMS provides an abstract view and hides details. For example, logically we can say thattheinterface or window to data provided by DBMS to a user may still be the same although theinternal structure of the data may be changed. (Refer to Figure 2).

Improved Integrity

Data Integrity refers to validity and consistency of data. Data Integrity means that the datashould be accurate and consistent. This is done by providing some checks or constraints. These are consistency rules that the database is not permitted to violate. Constraints mayapply to data items within a record or relationships between records. For example, the ageof an employee can be between 18 and 70 years only. While entering the data for the age of anemployee, the database should check this. However, if Grades of any student are entered,thedata can be erroneously entered as Grade C for Grade A. In this case DBMS will not be ableto provide any check as both A and C are of the same data type and are valid values.

Efficient Data Access

DBMS utilises techniques to store and retrieve the data efficiently at least for unforeseenqueries. A complex DBMS should be able to provide services to end users, where they canefficiently retrieve the data almost immediately.

Multiple User Interfaces

Since many users having varying levels of technical knowledge use a database, a DBMSshould be able to provide a variety of interfaces. This includes

 ─ 

a. Query language for casual users,b. Programming language interfaces for application programmers,c. Forms and codes for parametric users,d. Menu driven interfaces, ande. Natural language interfaces for standalone users, these interfaces are still not availableinstandard form with commercial database.

2|P age

C & Assembly Language Programming (Lab Manual)

BCSL-021 C Language Programming
Section – 1 C Programming Lab

BCSL-022 Assembly Language Programming Lab
Section – 1 Digital Logic Circuits
Section – 2 Assembly Language Programming

MCSL-017 C and Assembly Language Programming
Section – 1 C Programming Lab
Section – 2 Digital Logic Circuits
Section – 3 Assembly Language Programming

QUESTION PAPERS

BCSL-021 June-2012 (Set-1) (Solved)
BCSL-021 June-2012 (Set-2) (Solved)
BCSL-021 June-2012 (Set-3) (Solved)
BCSL-021 June-2012 (Set-4) (Solved)
BCSL-021 December-2012 (Set-1) (Set-2) (Set-3) (Set-4)
BCSL-021 June-2013 (Set-1) (Set-2) (Set-3) (Set-4)
BCSL-021 December-2013 (Set-1) (Set-2) (Set-3) (Set-4)
BCSL-021 June-2014 (Set-1) (Set-2) (Set-3) (Set-4)
BCSL-021 December-2014 (Set-1) (Set-2) (Set-3) (Set-4)
BCSL-022 June-2012 (Set-2) (Solved)
BCSL-022 June-2012 (Set-3) (Solved)
BCSL-022 December-2012 (Set-1) (Set-2) (Set-3) (Set-4)
BCSL-022 June-2013 (Set-1) (Set-2) (Set-3) (Set-4)
BCSL-022 December-2013 (Set-1) (Set-2) (Set-3) (Set-4)
BCSL-022 June-2014 (Set-1) (Set-2) (Set-3) (Set-4)
BCSL-022 December-2014 (Set-1) (Set-2) (Set-3) (Set-4)
MCSL-017 December-2010 (Set-1) (Solved)
MCSL-017 December-2010 (Set-2) (Solved)
MCSL-017 December-2010 (Set-3) (Solved)
MCSL-017 December-2010 (Set-4) (Solved)
MCSL-017 June-2011 (Set-1) (Solved)
MCSL-017 June-2011 (Set-2) (Solved)
MCSL-017 June-2011 (Set-3) (Solved)
MCSL-017 June-2011 (Set-4) (Solved)
MCSL-017 December-2011 (Set-1) (Solved)
MCSL-017 December-2011 (Set-2) (Solved)
MCSL-017 December-2011 (Set-3) (Solved)
MCSL-017 December-2011 (Set-4) (Solved)
MCSL-017 December-2012 (Set-1) (Set-2) (Set-3) (Set-4)
MCSL-017 June-2013 (Set-1) (Set-2) (Set-3) (Set-4)
MCSL-017 December-2013 (Set-1) (Set-2) (Set-3) (Set-4)
MCSL-017 Juner-2014 (Set-1) (Set-2) (Set-3) (Set-4)
MCSL-017 December-2014 (Set-1) (Set-2) (Set-3) (Set-4)



0 comments

Leave a Reply

Your email address will not be published. Required fields are marked *