Task 1.1: Selection of the case upon which the Database design and implementation is to be based.
You need to identify a suitable case study from which to derive your database requirements. This may be a situation based on a company with which you are familiar or in which you are (or have been) employed, or may be one (or based on one) that you have read about within the trade or academic literature or identified from their web presence. You need to ensure that your business situation is suitably complex to provide you with at least four strong entities, and at least one specialisation: generalisation structure, yet suitably scoped so as to not require a huge quantity of resultant tables (i.e., normally no more than 15) and subsequent input of sample data for querying purposes.
It must not be based on a library (video, book, CD or film) and not just solely about orders of products. It should not be one that is based on any previous examination scenarios for this module, nor any exercises given to you within your DS&D module lecture material and/or module pack. Once researched and identified, a written scenario needs to be produced that (a) provides relevant background information on the organisation (e.g., its purpose, its principal operations/structure, its products/services, its target markets, etc.), and (b) provides an overview of what operations a database would need to support. Your scenario will probably be no less than one side of A4, but no longer than three slides of A4.
You should aim to complete this task by the end of Week 6.
Task 1.2: Provide a conceptual database design for your scenario & the list of enterprise rules being modelled.
The second task is to develop an EER Diagram that captures the detailed requirements for the database system that you identified within the scenario you wrote to satisfy Task 1.1. The EER Diagram needs to show any weak and strong entities, the primary keys for strong entities, and any relationships between entities (including any generalisation: specialisation structures). *:* relationships must be decomposed, and any actual traps identified should be eliminated using appropriate methods. For each entity, there should be an associated written list of all the attributes that the entity possesses which are not written on the EER Diagram. Any assumptions made during conceptual database design (i.e., anything that you assume that is not written in your Task 1.1 scenario) should be listed.
As well as the conceptual database design, you also need to provide the exact list of enterprise rules that your EER Diagram is diagrammatically representing. (Every relationship will need at least one enterprise rule, depending on its multiplicity and degree.
IMAT5103 | Scenario & Conceptual Database Designing | Database Design
This project involves two tasks. For completing Task1.1, you have to identity the most appropriate case study from which you will actually derive the database requirements. This can be a scenario on an organization with which you are familiar, where you already worked, or might be the one you have studied either within the trade, academic source or internet. The task 1.2 requires you to produce an EER diagram for capturing the detailed needs of the database system that you have identified with in the situation.
Our experts make sure that you get the top quality academic papers on time
Many of the college students these days face problem with their database design projects. Our project assistance company help the learners from all over the world to solve their subject papers in a highly efficient manner. Our team provides top class IMAT5103| Scenario and Conceptual Database Design| Database assignment help to the learners. So, they can take academic assistance from our expert team any time of the day or night. Our experts make sure that you get the top quality academic papers on time. So, just send your assignment questions to us and we will solve your database design assignment in no time.
Leave A Comment