Analyse the conceptual database design

Assignment Help Other Subject
Reference no: EM133034522

KL7011 Advanced Databases - Northumbria University

Learning Outcome 1: You will be able to demonstrate critical understanding of the entire data life cycle and classical database engineering processes and approaches, and non- traditional database systems.

Learning Outcome 2: You will be able to demonstrate deep knowledge of key concepts of data warehousing, data analytics, data standards, and data quality.

Learning Outcome 3: You will be able to critically analyse, select, apply and evaluate advanced data modelling, database design, implementation and manipulation methods, techniques and tools to a complex data management problem.

Learning Outcome 4: You will be able to Appraise, analyse, design, develop and evaluate data warehousing and data analytics solutions using Oracle database system.

Learning Outcome 5: You will be able to develop critical awareness of the responsibilities of database developer with respect to professional, legal, security and ethical issues individually or as part of a team

- You are expected to produce a word-processed answer to this assignment. Please use Arial font and a font size of 12 for text. For SQL code and output, you can use courier new font and a minimum size of 10, which preserves SQL format and layout. Where necessary, screenshots of SQL output may be used instead of plain text.

- You are required to use the Harvard Style of referencing and citation. The "Cite them right" guide is recommended for referencing and citation (Pears and Shields, 2008) which should be followed throughout your answer especially Part 3. Please do not include references to lecture notes.

You are advised to read the guidance for students regarding assessment policies (Northumbria, 2020).

Assessment Background and Scenario

This assessment is based on the scenario MOVEHOME of a fictitious real estate group of estate agents. The group wants to develop an information system to support its activities. The details of the scenario are provided in the Appendix.

Assignment Questions

Part 1
This part is based on the MOVEHOME scenario as described in the Appendix.

(A) Using entity-relationship (ER) OR enhanced entity-relationship (EER) modelling, produce a conceptual design for the database to support the MOVEHOME business activities.

(B) Convert the ER / EER diagram from Part 1(A) to produce a logical relational schema using ER / EER to relational mapping.

Notes for Part 1 (A & B)
• The ER/EER diagram should show all relevant entity types, relationship types, attributes, primary keys, and structural constraints. Note that not all keys are identified/mentioned in the scenario, so you are required to identify/devise appropriate primary keys for all the entity types. Your ER/EER diagram must not show/include any foreign keys or any such attributes that represent foreign keys as these are logical and not conceptual concepts.
• As part of the mapping process, for each relation, you should identify appropriate primary keys as well as foreign keys (if applicable). Furthermore, you need to make sure your relations obtained from mapping your ER/EER diagram are in the 3rd normal form.

(C) Based on your logical design from Part 1 (B) and the information available in the scenario, produce an SQL script file using Oracle 11g/12c/higher.

Part 2

This part is based on your answer / solution to Part 1, i.e., design and implementation of the database for the MOVEHOME scenario.

(A) Populate the database with some sample data (e.g., you should generate your own dummy data and load it into the MOVIEHOME database, consider 5 to 10 rows for each table and enough data to see meaningful output for the queries below).

(B) Answer the following queries (retrievals) using Relational Algebra and SQL.

q1) Display details of semi-detached properties for sale having at least three bedrooms in the Jesmond area of Newcastle upon Tyne that were added to the system in the last 14 days.

q2) Display details of properties sold in Newcastle, Sunderland, Gateshead or Durham for £157,000 to £279,000 in the years 2019 or 2020.

Part 3

This part is based on your answer / solution to Part 1 (A), i.e., conceptual design of the database for the MOVEHOME scenario.

(A) Choose and justify what aspects of MOVEHOME conceptual design would be better off if implemented using object-relational database; then provide logical design and implementation of the subset of the MOVEHOME using ER/EER to object-relational mapping and object-relational features of Oracle Database System (Kannan); populate the object-tables with sample data and demonstrate your choice of design and implementation by running two complex queries on your object-tables.

(B) Analyse the conceptual database design from Part 1 (A) and the MOVEHOME scenario in the Appendix and propose what aspects of the MOVEHOME database would benefit from incorporating NoSQL Database concepts. Illustrate your answer with code from a representative code from NoSQL Database implementation.

Part 4

Consider the MOVEHOME scenario in the Appendix. Produce a report for the managing director of the MOVEHOME group elaborating on professional, legal, ethical and security issues that need to be considered and make recommendations that you think are appropriate for MOVEHOME.

The report should be concise and comprehensive and in the region of 800-900 words. You should use Harvard style of citation and referencing by following the guidelines in Pears and Shields (2008).

Attachment:- Advanced Databases.rar

Reference no: EM133034522

Questions Cloud

Give the methods of cookery : Choose two dishes from our menu at work or if you are not currently working then choose two dishes from any menu.
What are the key factors in organizational performance : What are the Key Factors in Organizational Performance? (Need there are 3 or 4 key factors.)
Critical analyses of a single issue : First, review the module resources you have so far encountered, as well as your work in Module One. In addition, it is suggested that you visit the IDS 400 LibG
Internship placement coordinator : The following questions should be answered by the intern independently and submit them to the internship placement coordinator.
Analyse the conceptual database design : Analyse the conceptual database design from Part 1 (A) and the MOVEHOME scenario in the Appendix and propose what aspects of the MOVEHOME database
Determine the effect on ridership : UBER is facing a large number of lawsuits, among them a charge of technology theft from Google, installation of software that blanks out the availability of UBE
Calculate the total estimated cost : Enter a formula in cell B25 to calculate the total estimated cost. The total estimated cost is the sum of the base house price (B9), total interior upgrades (B1
Design changes implemented by knudstorp : Lego has long been an industry leader in children's toys with its simple yet unique building block-style products. A Danish carpenter whose family still owns Le
Identify areas for growth in organizational diversity : Identify areas for growth in organizational diversity within your current organization, career, or industry.

Reviews

len3034522

11/23/2021 11:29:53 PM

Go through assignment in proper 2 times before you start to understand it As I failed already in similar type of assignment earlier So take extra care I need best one Please do it carefully, follow each and every instruction and Marking Criteria and References

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd