Database Design And Development
TASK1
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, S
tudentN
ame, DateOfBirth) Enrolment (
EnrolmentID,
Student
ID, DateOfEnrolment) or:
Student (
StudentID, StudentName, DateOfBirth)
Enrolment (
EnrolmentID,
Student
ID, 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.
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.
Show the details of researchers who have never submitted a proposal.
Show details of proposals that have been reviewed but don’t have any recommendation.
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.
Show the experts’ names and number of proposals reviewed by them, who reviewed more than one proposal.
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 UniLearnO. 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.
Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!