Hi Can you please answer this sheet of paper about Database Systems?

 

1.Relational Databasesa.What are the basic components of a relational database? (Know all names for theparts)b.What are the different types of keys?c.What is referential integrity?d.Know the various operators that can be performed on tables and be able to explaintheir results.e.What is an outer join?f.What is the purpose of a relational database?g.What are nulls?h.What is a logical view of data?What is a physical view of data?i.What are the characteristics of a relational table?2.Extended ERDa.What are subtypes? Supertypes?i.What is are the different types of completeness? How are they depicted ina diagram?ii.What are the different types of discriminators?How are they depicted in adiagram?iii.What is a sub-type discriminator?b.What is inheritance?c.What is an entity cluster?d.What are the following?i.Attributesii.Entitiese.What do specialization hierarchies do?3.Normalizationa.What is normalization and the goal of normalization?b.What is an anomaly in reference to databases?c.What does it mean for data to have functional dependency?d.What does it mean to functionally determine data?e.What are the definitions of first, second and third normal forms?i.What is a determinant?ii.What is a dependent?f.What are the different types of dependencies?g.What is denormalization and when would it occur?h.Explain how database designers design and normalize databases.

• 1495074797-Database.docx

SuperTutor

(15)

Status NEW Posted 18 May 2017 02:05 AM My Price 8.00

-----------

Attachments

file 1495074800-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer