INFS601 - Logical Database Design - IT Assignment Help

Assignment Task

Part A Entity Relationship Modelling and Logical Database Design

Task 1 - Identify Entities & Develop Business Rules
Identify all entities and relationships in the case study and develop a set of business rules. You should follow the syntax given below. Each relationship must be described by two rules, one in each direction.
Each/A/An ENTITY_1 May/Must Relationship_Verb_Phrase number ENTITY_2

Task 2 - Construct a logical Entity Relationship Diagram (ERD)
Based on the business rules developed in Task 1, construct a logical ERD for the case study using the Visual Paradigm tool.
• Identify all attributes in each entity including all primary and foreign keys (any composite and multivalued attributes must be transformed according to the rules of the relational model).
• All relationships must be named (i.e. Verb phrases must be shown for all relationships)
• If super/subtypes are used, indicate whether the super-subtype relationships are disjoint or overlapping, and fully or partially specialised (complete or incomplete).
• Identify the Cardinality and Participation for each relationship.
• Resolve all M:N relationships.
• Describe any assumptions you have made in a text note in the diagram.

Task 3 Use Normalisation to validate your ERD
(a) Use the technique of normalisation to validate your logical ERD data model . Demonstrate that each of your relations is in third normal form (3NF) by displaying (a list of dependencies) the functional dependencies between attributes in each relation. Note, if any of your relations are not in 3NF, this may indicate that your ER model is structurally incorrect or that you have introduced errors in the process of deriving relations from your model.

Part B Database Implementation

In this part you should develop a database based on your logical ERD developed and validated in Part A. You must populate the tables with sample realistic data.

Task 4 Create tables
Create the tables in Oracle. Write SQL scripts defining each table. The table definitions should include
(1) All attributes with appropriate data types
(2) all appropriate constraints such as primary key, foreign keys, and check statements.
All constraints must be given names. Naming standards must be used. 

This INFS601 - IT Assignment has been solved by our IT experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.