Hello,

I have 3 questions here about Databases in regard to Microsoft Access.

See attached word document for questions and please give your response within the document.

These are fairly simple questions about functionality of table relationships, composite keys, normal to third normal form etc..

please be descriptive as possible.

Let me know if you have any questions. Thank you.

Try to keep answers between 1-220 words.Q1)The Consulting.accdb database depicted in the following relationships diagram keeps trackof projects for a small consulting company, including information about the client whorequested the project and the employee in charge of the project. Use this diagram for thisquestion and the next one:Assume that referential integrity has been enforcedin the relationship betweentheCLIENTandPROJECTtables.a) Describe what impact this has on the data in both of the tables (refer to speciFc Feldnames and table names)b) Assume that “ Cascade Updates” and “Cascade Deletes”arenotchecked. Describe theimplication this has on the data in both tables, using speciFc table and Feld names in yourresponse.Q2)Using the diagram from question 1, describe the relationship betweentheEMPLOYEEandPROJECTtables.In your description, include details about the relationship type, the primary key and theforeign key.Use speciFc Feld and table names in your response.Q3)

• 1495089254-Microsoft Access - Database.docx

SuperTutor

(15)

Status NEW Posted 18 May 2017 06:05 AM My Price 9.00

-----------

Attachments

file 1495089256-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