Database managment system Handwritten notes, Study notes of Database Management Systems (DBMS)

Download Database managment system Handwritten notes and more Study notes Database Management Systems (DBMS) in PDF only on Docsity!

DBMS Handwritten Notes

— i. TWdicin ‘Databases — —— — iL Basic. Concep|s_ of_dotahases lata Dolchows dala rae tly lot el ay ef is y erdicin banceeaxed - wri and manipulated efFici lt seyve epnsi ie In dglatiie ihe is sical hls cles fe ach fable consists of rows Creards) and column: relations - F (attributes) thal pecan —fvenk pices cf ifommlion — Dale: processed _{o_pioduce information: Daldhase. Management System (Dans) inter-relaked data and programs to acess those. data: _ ‘The. challengas for data management Traditional file-based data management appr suffer Hom several challenges such in@nsistency and isolation. Data Redundancy: In file- based systems data ts olen aa cluplioated accross multe le. Silas or applications - This | J a ie ai a armani Lie lier + a eaecharicaS aichikechire is of two types like: — | a-tier orchiteclure and a-tier architecture. =~ — i. Tier_Archibor eh i dh ml eee _ond uses it | Che 1 doesn't provide a handy toolennds user: 2-"Ter_Anbideckie: ! The 2- Tier Arcibecture \s sami ds basic client Application client User: Fig: &tier architectare, ie GaTer Arhileclure Pe [The 3-+ier architecture. contains _la dient an sewer. In this. ionde._with <« SPyVveEr- yer pele the architecture. ura cai direct! on a4 [Datebase] Seiver Application Sewer) Application clien dient [ User | fig 3-tier Architectuve. 113 Dela Madels (relational, hierarchical nehwork. eke) Data Models ca [rated Se aa ae __data model dala mode!___ Relationship based | dara Medel model TT 4 Advantages and disad vanta Lagos of sing_0805 5 Advanlages ok usin ising Dems: ~ |f:Data inkegity: Databases. enforce data ink jeqnty conshaints such as_primar ny keys keys. foreign keys and. unique. cons traints_,to | peor rae es ele ae ! This_ensures ier ace teliahle. and free iam inconsistencies aia) aad, Various security features ,such es, ____.as access control ,qunthenticalion. Cg om on, to eet 4 gensitive information fiom unauthorixed acess dnd breaches: 5: Data shaxing: Databases enables. m iple_asers_and opp” ____}Ho acress_and_modify data concurrent be fall Aisa ak sas cy eal nagemenrt, ‘eading to beter data sharing actoss_an_ o. ae 4. Dala lant pt dence,, | Seprotingd busical storage of data from tht. logical view: Coe ea oe Oo be Made to tne database, _ JE Siuene, tthour affecting the applicatio tee. se the, _ ! data, makina maintainance, and Scalabi th ROdicee 5: a Backup and Recovert| : Databases _o or Mechanisms “for esfre. ink al. hat dala rn dada “baekups_and 1 pal sat a | DBs Ee sie ——_| tse Shin ng up ee ee ee a Fee ii Ore gma icences training a intainanee. | | (etal: ey a Jala di “1 esiqning dnd tnanaqing detabasas require. $ ’ irs Hale che i Nal “he. comple of dot tis : tay be. challen aging. for_non- axperts to understand mei ka Sige “oil 3b failure. A dos Failure can tat the entire. — roper backup and see v4 nisms. re. bnob _ aoa lace». data los an occlu, lacking to signi ‘cant dis- ions." th o 1S ies scalability. dal lenges: As data volumes. grow, _ sling lates to handle. corer vs —become.._comple and\_co — ___| Ensuring igh performance _un ev _heav f-ba om “can beach a en Eli Aki that devends on ancther ent iy yc i; ~ | wedenlily “The weak entity doesn't. sig any ‘Ei ibute. toils un Tee nf a repesied. ail ado [Tees J sine ere na le at a tihibule : The altibule. is used 4a describe the an. | ently: Eclipse. i is used to represent an altyibute: Te = i eg Sil ag. contact qumbort name Mescuy to, alditkes. of name [ Phone el a 5 tckidenl Serre | Ghudentt (id) (292) | | | _ Simple altnbute! Ht is also known as alamic atbibules When an _ | alibule cannot be divided further, then it is mleded. ae athibute: Fite} name, only single. value Leg Dok - Bith date | ‘Mull — valued valued _atibule: Those atfibules which can have more than ane enhy. 0 or which contain move than one value ave called ulti véilued odtibutes. ae Mobile re cr . can have many _nwnbers) one ie iS a ample alhtoade. if i oF RETR clasemate (oe oe) oo uy = [eq name. ycsbighs name, \usbviiae., Alea ae | oo [Derived _olbribute Tie loa ee: anther oe ute. dexived trom _anb pees | othibute those abhi called Desived attibute sheet Tes, es) in. decal ele oe "|__| @ludent ae ae | student -id _| ; ee | Name 2 Name- fn Name - Mn Name: Lo ; Phone not . DoB age() Eee Lone oe de between cntitias. Diomand ov yvhombus is used to represent Ahe. iclakiansbip : x er — student [gpes rs relahionships are_as follows: 1: Ope _4o one Relationship (1- D with» the ep a ane acid nen colon inlanee. of an ey is assedeed jp- eq ‘A female can many to one mele. and a male can tary a one female 192 Entity - Relationshi \ike person, a cy) ts diagram (ERDs) —__ “REESE osc model for — Lenlilies tobe represented. in the, dalebase and representation Lot how those enlibies are elated. The Enlily ‘eh Dicqeam explains the. yelakionshi the daltbase: £R models are used 4o madd real - orld_objeds e_ relation between 1 a_company_and 4th these real world object. Pokitie dulubace. ~ f no the. entities vesen in ationshi SER diagram is the shuclural format Sumbols Used in ER Model : Reclanale, Entilies in ER model Edipse. SO) Afnbules in ER model Diamond <- Relationships Line —- connection belween entity and relationshic Weak entity : : ot Double rectangle, Double Ellipse ‘e) ‘Mubti-valued athibutes | underlined otmbude. A primary ket Seer nic : ; dothec| allipse. ee derived abtibute : | = | ae | fine an de diagram: i ER Diagrams for marks database - pa | ess Marks ae y! | student pote Sechion Lid ~— sec-id Lec-cowrso name A ‘sem SS depk_namel year dob cred course exam course. id | exam-td title f name credits Place. time *|ER diagram for favourite team statistios | |score! | [match 1 [ player match_ic Player ated || date name. | | stadium age || opponent Sedson score) | own. score, { Opp— Soore ——~"T elit I ——— (sai Sia aaa: There. con be one of more.’ Nan Lone. ety that can assocdake with one or more than one ot another gel. | sat — | sel! edi. oy as | SERS Mon re Lt PS Se ioe | aby Lis ji Nace Neeaw/. One +0 many (1:04) “There can be only one entity, Shot can _ assoc with one or more than one entily ck another ad sel ! — f= | —=———— en | ie {2 \_ Bl viz eu) ew’, Paaticipalion in Database! Tha rlolonship.. participation conshaint specifies the existence. of an entity. when ik is related to anothe: entity ina 1a lationship type Ik is also called_mininwson cardin iol: There. are two apes of peslitypation constraint — |) “a_parlicipaken ; Patil atain : “ill tkipalion Esch erly in de enlly seh is_invlved ia. at least one telabionship i a relationship aie the _ nutrbet_of;teationships_in every enlily is involved ts greats. | Mee a ie ” ;, ' —+ [Empyee] Ml “york _ Department gc eee oY Bed 4 | Binary keys _Candidele bey Super he Faefgn Heys —__ Pinan kes! “Fie candidabe. ke alabase ds: | Dee aly ke as_a_paimen) medns it can i. oO rr ~~ _ [Foreign beys cre the column_of the fable used to point i he | primany-heys. oF another table | i . ~ will oe eteiter os | —_— r HT ae + Bo | ee ee None ih ——f See ene sree | | _lassport enumber License—number : i {| i | | | i | | seas | = nal_gchema au é é a 3. wie Data -edel ___— — | rT yelattanal ial caddis is Dame ie the. | ielation aad ndme of all_ columns or athibules: | , In the velational key. each rou) has one ar more otvibute ste | Ex:_otud ent Relation Name | RoH-No | PhoneNo_| Address_|Age { Ram | 14795 | 000007777 | Noida | 24 | shyam | 12834 | 1111123228 | _delhi_| 25 [taxman | 35aeq | 2anagasse | delhi | 25 | Ganu 17282 Wut Mumbai | I | 5:2 Relalional Algebree: Relatpnal_olgebra_is_a theoretical query lanquag “nel pl Aolinatn aetna see ee lasas- [t+ cons. ___llists- of asset ‘of o ians_that- canbe. peiformed_on relations (tables) to aehrieve. desived information ere are. | Some_comion—elational_algebra._operatione_uith an | Oxample: i