Describe how you have represented weak entities

Assignment Help Computer Engineering

Reference no: EM133361847

Question: DB Specification & Implementation: After you have developed the conceptual E-R model for GG, convert that data model into a relational database design for Garden Glory. Then develop the specifications for database implementation, indicating data types, PKs, and FKs. Implement the design and create the GG Database and execute a variety of queries to test the functionality of your DB. Document your database design and the processing results accordingly. You can also refer to the GG project questions in §5.

Describe how you have represented weak entities, supertype ,and subtype entities, if any exist.
Document referential integrity constraint enforcement actions; use the Template table Figure D3.2 below as a guide and see Chapter 5 in the textbook for an example.
Document any business rules that you think might be important. Describe how you would validate that your design is a good representation of the data model upon which it is based.
Implement your DB design in MS Access. Create tables, create relationships, enter sample data ( see the sample data in previous deliverables and/or feel free to make up some sample data as appropriate), create data entry forms and reports as necessary, and use SQL or QBE to query the DB and test its operational performance.

Reference no: EM133361847

Questions Cloud

Prepared for unexpected change : What are some other ways you think organizations can be prepared for unexpected change?

Explain the treatment plan which is anticipated : Explain the treatment plan which is anticipated for this patient based on National Best Practice Guidelines.

What are some other tools that you would have wanted : Reflect on whether you believe these collaboration tools are satisfactory and explain your rationale. What are some other tools that you would have wanted

Name different sites for measuring body temperature : Name the different sites for measuring body temperature. Where can we measure the most accurate body temperature and why?

Describe how you have represented weak entities : Describe how you have represented weak entities, supertype ,and subtype entities, if any exist. Document referential integrity constraint enforcement actions

Identifying waste and resource management : Think about the clinical environment where you work or one in which you previously worked.

What type of built-in python collection would be a good : What type of built-in Python collection would be a good choice for representing a queue in which the first item in the queue is the first item out of the queue?

Proposed quality improvement plan : Present a model (STEEEP Pursuit of Excellence) for use in your proposed quality improvement plan

How the dynamics of reporting and built-in analytics : Extensively evaluate how the dynamics of reporting and built-in analytics (Google analytics) is helping Air Canada support decision-making.

User Account

All Pages