CST2340: Write a detailed description of your chosen organisation: Database Systems: Design and Implementation Coursework, UK

Looking For Plagiarism Free Answers For Your UK College/ University Assignments.


CST2340: Write a detailed description of your chosen organisation: Database Systems: Design and Implementation Coursework, UK

UniversityUniversity of Oxford (UO)
SubjectCST2340: Database Systems: Design and Implementation

Case Study

This coursework should be carried out on a relevant case study. Be realistic with your case study by choosing a small to medium organisation – for example, large multi-national companies will be much too complicated. Some examples of suitable organisations are:

  • A Bank (Individual Branch)
  • A Local Retail shop
  • A Library
  • A Doctor’s Surgery

 Your Tasks

A1.  Case Study Description.

Write a detailed description of your chosen organisation, concentrating on the data requirement. Your description should state any assumptions that you make about the business rules of your organization.

A2.  Entity-relationship model mapped to a relational database

Start by producing an Entity-Relationship (ER) Model using UML notation for your chosen case study. Then convert the ER model to a Relational Model by specifying the Primary (PK) and Foreign Keys (FK), mapping any one-to-one relationships into relations, and decomposing any many-to-many relationships.

This is the Entity-Relationship diagram and the Relational diagram, which you should submit.

Do You Need Assignment of This Question

A3.  Validate the Model

Checking for Connection Traps

Examine your model and identify one potential trap (fan trap or chasm trap) – if present. Consider whether this may cause a problem to your model and re-draw if necessary, arguing your case either way.

If you cannot identify a trap in your diagram, you need to clearly explain one type of trap and discuss how it could be resolved.

Supporting the Functional Requirements

Validate the model by showing that it can support one of the functional requirements identified in A1.

Indicate the access path clearly on a copy of your ERD (or a subset of it) and explain your diagram.

A4. Limitations of the Relational Model.

  • Discuss the limitations of the Relational Model.
  • Discuss the NoSQL model including how this model could overcome some of the limitations of the relational model.

A5. Professional, Legal and Ethical Issues

Discuss the professional, legal and ethical issues that should be considered when designing and managing a database.

Buy Answer of This Assessment & Raise Your Grades

Get help by expert

If you are struggling to complete your HND assignments or need some assistance in writing and researching, we are here to help. At Diploma Assignment Help UK, our team of experienced professionals can provide you with expert support that meets all your HND assignment requirements. So connect with us now and get the best HND assignment help at affordable prices.

Recent solved questions

sample image
Hire An Assignment Writer