COIT20247 :Database Design And Development - Data Modelling - ER Model Assignment Help

Database Design And Development

TASK1 ER model 1 . According to the ER model given above, answer either yes or no to the following questions:
  • Does every member have arental activity?
  • Has every car everbeen rented?
  • Is the relationship between Location and Rental modelled as a many to many relationship?
  • Are there any other possible typesof car?
2 . Convert the ER model given in Part A into a set of relations that satisfy Third Normal Form (3NF). You do not need to show your workings. You do not need to juvtify that they are in 3NF at this stage. You do not need to show sample data. Just show your relations. You should write your relations in either format shown below: udent (StudentID, StudentName, DateOfBirth) Enrolment (EnrolmentID, StudentID, DateOfEnrolment) or: Student (StudentID, StudentName, DateOfBirth) Enrolment (EnrolmentID, StudentID, DateOfEnrolment) Foreign key (StudentID) references Student 3 . The following relation is designed to include a rental activity as described in Part A. You may assume that the combination of member’s licence number and car Identification number uniquely identifies each row/tuple in the relation. Examine the relation and answer the questions that follow. Relational model and Normalivation If the information of car make “Honda” is deleted from the relation, justify what type anomalywill  What is the highest normal form that this relation satisfiesand why?  Normalise the relation into a set of relations that satisfy 3NF using theformat as follows: Relation 1 (ID1, Abc, Def,…….) Relation 2 ( ID2 , ID1, Hij, Klm,…..) Foreign key (ID1) references Relation 1 TASK2 How many proposals did each expert review? Show the expert’s ID, name, expertise and the number of proposal reviewed. Order the result by expert’s first name. Databave Devign and Development Show the details of researchers who have never submitted a proposal. researchers who have never submitted a proposal. Show details of proposals that have been reviewed but don’t have any recommendation.   proposals that have been reviewed   Show the researcher’s name and expertise as well as the requested funding, whose proposal has the highest amount of requested funding among all proposals.  researcher’s name Show the experts’ names and number of proposals reviewed by them, who reviewed more than one proposal. Databave Devign and Development TASK3 Briefly explain what is meant by referential integrity constraint. What is meant by normalization of relations? Why is it necessary to perform normalization during the database development? Differentiate ‘data warehouse’ from ‘data mart’. Briefly discuss the two important goals of a distributed database: Local autonomy and Location transparency. Explain the difference between an exclusive lock and a shared lock. Briefly discuss each of the typical backup facilities in a modern database management system.
The above question has been solved by our Database Design And Development experts at TVAssignmentHelp. 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.
   
  • Author : sam
  • Posted on : November 30th, 2018
  • Downloads : 0

Download Solution Now

Review Question

Please enter your email

Need Instant Assignment Help

Choose a Plan

Premium

40 USD

  • All in Gold, plus:
  • 30-minute live one-to-one session with an expert
    • Understanding Marking Rubric
    • Understanding task requirements
    • Structuring & Formatting
    • Referencing & Citing
Most
Popular

Gold

20 15 USD

  • Get Full Solution
    (Solution is already submitted and 100% plagiarised.
    Can only be used for reference purposes)
Save 25%

Silver

10 USD

  • Journals
  • Peer-Reviewed Articles
  • Books
  • Various other Data Sources – ProQuest, Informit, Scopus, Academic Search Complete, EBSCO, Exerpta Medica Database, and more