See the attached file

********************* ****************** DateDiscussion1 **** ** a ********** of ***** ***** *********** ** the ******** ** ***** ** ***** **** into ******* *********** ** ********* ****** **** that ***** ** ************ * ********** ****** ** categories ** *** **** ***** about ***** **** is ****** ** ** ********* collection ** ********** information or data commonly referred ** ** a ******** The database ********** ****** will identify * ******** ****** *** ******** *** ******** ** ****** * database ****** ** a **** ********** ** ************ data * ******** ****** ** a software that ** used ** ******** store and retrieve **** **** *** database *** ******** ****** components include;-Storage engine-Query ************** ********************** *************** *********** manager-Reporting *** ********** ********** ********** ******** ********** ****** helps ** **** dictionary management ************* *** definitions ** **** ******** *** revealed **** **** *** as helps ** the ********** ** data ******* ** creating ******* structure **** can get *********** b **** to store data **** ********** ******** of **** ** ************ ****** ****** ****** **** ******** *** *** backup ********* the **** guarantees ********* *** safety ** **** ** ********** ** providing ****** ********** ***** ****** ****** A ******** ******* **** ****** ************** ** ********* ** *** **** ************ **** ************ ****** ********** *** DBMS ******* ******** ***** *** ****** *** **** **** ******* *** **** ***** interfered with *** **** integrity ********** is ******** as ***** *** ******* ***** **** prevent **** ********** and ****** **** maximization *** ********** when ****** **** include data *********** **** ******** ***** access ***** ************** and outsourcing ******** ********** **** ***** In the ********* * ******* ** *** ****** how **** * document is **** **** document *** created among ***** *********** *** ****** ** ** **** in the DBMS **** * **** ***** ** retrieve ** ***** **** *********** ********* *** *** *** author date *** ************ when ********** or ******* *********** ** *** ***** ******** ******** *** ********** ****** The ********* ****** ***** ********** ******* of *** DBMS *** ******** mapping *********** *** **** ********* ******* **** ********** Language ***** (Utilized ** * **** ********* Data ************ ******** ***** (Used ** a person *** wants ** insert delete or ****** * **** of * ********* **** ******* ******** ***** ***** ** ** ************* ** ****** ****** of ****** *********** ******* Language ***** (It can ** **** ** an ******* or ************* ** ********** Data dictionary *** **** ** show detailed ******** ad evaluation ** *** ******* ** * ******** Details **** as ***** *********** *** ********** ***** **** ******** *** ******** Companies ** *** create **** as **** ***** *** **** by cyber-criminals ** access ********* ************ *** ***** ****** architecture is made up ** the ******** conceptual *** ******** schema *** internal schema ***** *** identifies the physical storage ********* ** *** ******** The ******** ****** contains *********** that show *** user the specific ***** ** *** ******** **** *** ********** in *** conceptual ****** describes the ****** database ********* *** ********* ************* *** ***** ** data ****** *** ******** ****** represents *** logical **** ** * database ***** *** database ***** ***** *** ******* of *** database10 **** ************ ** *** ******* **** ********** the ********** ** ********* *** ****** **** **** ************ **** *** use **** ** computation or ************ ******** ******** data independence ****** **** *** modification ** *** physical ****** ****** ******* ******* *********** ******** ** be ********* ******* data independence means **** modification ** the ******* schema occurs without causing *********** ******** ** ** rewritten11 *********** ******** is ******** ** banks ******** *** ********* ** **** integrity ** ********** It ** **** *** * ******** ******** ********* *********** that ******* ***** ********* **************** projects *** ****** ********** under * *********** database ****** * ************* ******** is ******** **** ********** applications **** might ****** many ***** It ** ******** ******* ** *** better response ** challenges *********** ************ *** ******* ********* are ******** *** * ******** application logic ** ****** ****** ****** *** **** interface ** *** ****** ** within *** database ** *** ****** *** ***** while *** * In ********** ************ the *********** ***** ** process resides ** the middle-tier ** ** ********* **** the data and *** **** ********* A ********** ** better and practical ** ********* as **** **** *** be ********* ** updated ******* affecting ***** ******* A non-functional *********** ** * ****** ********* **** acts as * restriction ** * design *** ******* ******** *********** *** *********** ** *** ****** the ************** requirements are defined in *** ****** ********* and *** maintainability ** the ********* ******* **** include ********** **** ***** ******* *** * ******* data ***** *** ******** ERD ** *** ** * structural diagram ***** ********** *** to **** overall ******* of a ****** Logical ***** created ***** creation ** a ********** ***** and ***** more ******* *** ******** ***** ******* **** ********** ******** ***** ** demanded15 ********* ************ occurs when *** ******** ** *** **** type **** * ************ For ******* when ** ******** ** mandated to ********* ***** *********** * ******* ******** ** **** ** **** ************** ** ** ERD ** is *** ****** ***** as ***** are times when * ****** entity ****** **** into ******** sub-entities *** ** **************** ********** for ******* ******* ******** for example *** is * ******** *** animals *** **** ****** **** Union **** ************ ********** * ****** ******************* ************ with **** **** *** superclass For ******* * ******* ****** *** ** a ******** student ** * *********** Schema-RecordDatabase-set ** ********************************************************* field20 ******** inheritance *** **** to * *** ** ********* **** *** base ******* ********* * method **** *** **** **** It ** **** ****** **** as ******** ******* ** ****** ******* the ******** ******** can *** the ********* of the **** ****** ********* ** ** ****** ******* ** **** organizations21 Redundant *********** occurs **** *** same **** ** ******** ** multiple locations ** *** database ** ***** ** **** ************* ***** ** inefficiency **** ********** and *********** ******** in ********* * A ****** ** a ****** *** ** ****** ********* *** ** ********* ** * ***** **** *** **** storage of **** *** **** ************ Domain *** values that go ** a function -Used ** ******** *** ****** from ********* associated **** a ********** ********** is a ****** ** ***** ** ******* ** a ***** **** ******** ******** ***** row ** **** tableSecondary-It is column or ***** of ******* ** a ***** that uniquely ******** ***** *** ** **** *************** It ** a * candidate *** that consists of *** ** **** ********** (table ******** **** together uniquely identify ** ****** occurrenceforeign- ** ** a column **** creates * ************ ******* two tablescandidate- ** ** a ** * *** of ********** **** ******** ******** ****** in a ************* *** ******* Key ********* *** ********** ************** ********** ********* *** ************* Referential ********* ** *** ******* ********** of * ******* *** ** * ******* *** A **** ********** ** ******* *** *** of ******* and ********* *** to ****** that *** ************ ******* *** ****** ***** in **** during *** execution ** *** ****** *** delete instructions25A “Unit ** ******* ****** ** the *********** sequence ** ********** within ** *********** *********

Click here to download attached files: erdtopic (4).docx