Scribd
Upload
65 views3 pages

Database Management Systems Unit-I

The document discusses key concepts related to database management systems including: 1) Databases allow for organized storage and retrieval of data through DBMS functions. A DBMS manages storage, retrieval, security, and integrity of data. 2) There are different data models including hierarchical, network, and relational models which influence database design. 3) Database design involves normalization to reduce redundancy and dependency. Other challenges include conflicting goals and ensuring data integrity through integrity rules.

Uploaded by

Mutharaju Surya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
65 views3 pages

Database Management Systems Unit-I

The document discusses key concepts related to database management systems including: 1) Databases allow for organized storage and retrieval of data through DBMS functions. A DBMS manages storage, retrieval, security, and integrity of data. 2) There are different data models including hierarchical, network, and relational models which influence database design. 3) Database design involves normalization to reduce redundancy and dependency. Other challenges include conflicting goals and ensuring data integrity through integrity rules.

Uploaded by

Mutharaju Surya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 3

DATABASE MANAGEMENT SYSTEMS UNIT-I

1) what is database? Explain the advantages of DBMS? 2) Explain about different types of database? 3) hat is file syste!? Explain about proble!s and li!itations with file

syste! database !anage!ent? ") Explain about DBMS fun#tions? $) hat is data !odel? Explain about different types of data !odels? %) Explain briefly about Business &ules? ') hat is Data (bstra#tion? Explain about 3 levels of views )or) 3 !odels of data abstra#tion? *) Explain about &elational set operators? +) hat is data di#tionary? 1,) Explain about -ntegrity &ules?

UNIT-II
11) 12) 13) 1") 1$) 1%) 1') 1*) 1+) 2,) 21) 22) 23) 2") hat is E&.!odel? Dis#uss about E&.Model? hat is degree? Explain about different types of degree of &elational ship? hat is data redundan#y hat is &e#ursive &elationship? rite about database design #hallenges #onfli#ting goals? hat is /or!ali0ation? Explain about different for!s of /or!al for!s? rite about i!proving the design? rite about database design #hallenges #onfli#ting goals? hat is /or!ali0ation? Explain about different for!s of /or!al for!s? rite about i!proving the design? hat is a surrogate 1ey? Explain about different types of 1eys? hat is denor!ali0ation? Explain briefly? a2 hat is EE& !odel? Explain about super type3subtype &elationships Explain about 4enerali0ation 5 spe#iali0ation? Explain about entity #lustering?

UNIT III

25) 2#) 2$) 2*) 2-) 12) 17) 12) 11) 18) 15) 1#) 1$) 1*) 1-) ",) "1) "2) "3) "") "$)

Explain about DDL comman !" Explain about DML comman !" Explain about i%%&'&nt t(p&! o% ata t(p&! in S)L" Explain about !&t op&'ato'! +it, &xampl&!" Explain about .i&+!/.i'tual tabl&!" 0it, &xampl&!" 0,at i! 3oin" Explain about i%%&'&nt t(p&! o% 3oin! in !4l" a5 0,at i! !ub 4u&'( 6 co''&lat& 4u&'i&!" Explain +it, &xampl&!" 0,at i! an o'acl& !&4u&nc&!" Explain it b'i&%l(" 0,at i! cu'!o'" Explain b'i&%l( +it, &xampl&!" 0,at i! !to'& p'oc& u'&" Explain +it, &xampl&!" 0,at i! !to'& %unction" Explain +it, &xampl&!" 0,at i! T'i99&'" Explain +it, &xampl&!" 0,at i! 9'oup b( 6 :a.in9 clau!& &xplain +it, Exampl&" 0,at i! ataba!& &!i9n" Explain about SDL;" a5 0,at i! In%o'mation !(!t&m" Explain about DBL;< ataba!& li%& c(cl&)" Explain about ataba!& &!i9n !t'at&9i&!" Explain about c&nt'ali=& 6 &c&nt'ali=& &!i9n" UNIT-I> hat is transa#tion? Explain about transa#tion properties? hat is #on#urren#y #ontrol? Explain with lo#1ing !ethods? 6on#urren#y #ontrol with the sta!ping !ethod? 6on#urren#y #ontrol with opti!isti# !ethods? Explain about database re#overy !anage!ent? hat is Distributed database !anage!ent syste!? Explain (bout advantages and disadvantages? "%) Explain about #hara#teristi#s of distributed database !anage!ent syste!s? "') Explain about DBMS #o!ponents? 5DDBMS features? "*) Explain about distribution 5 transa#tion transparen#y? "+) hat is two.phase #o!!it proto#ol? $,) Explain about distributed database design? $1) Explain about #lient3server vs ddb!s ?

Unit-.

$1) +,at i! ata +a'&,ou!&" Explain t,& n&& %o' ata anal(!i!"

52) Di!cu!! about !!" 51) 0,at i! !ta' !c,&ma" Explain about !ta' !c,&ma" 58) Di!cu!! about ata +a'&,ou!&" 55) 0,at i! ata minin9" Explain about ata minin9" 5#) Di!cu!! about ?LA@" 5$) Di!cu!! about !4l &xt&n!ion %o' ?LA@" 5*) Explain about AData a! a co'po'at& a!!&tB 5-) DBA Tool!" #2) Explain t,& n&& %o' 'ol& an ataba!& a mini!t'ation %unction"

You might also like