Free Samples
COMP2761 Data Modelling Assignment
.cms-body-content table{width:100%!important;} #subhidecontent{ position: relative;
overflow-x: auto;
width: 100%;}
COMP2761 Data Modelling Assignment
0 Download7 Pages / 1,569 Words
Course Code: COMP2761
University: Flinders University
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Australia
Question:
You also need to justify the reasoning behind the derivation (e.g. why does it contain a foreign key, can the foreign key be NULL, why has a particular ON UPDATE been chosen, etc.)
Answer:Primary key (MembershipNO)
memberName is a composite attribute and forms fname and lname as well as address which forms street and postcide. Member entity is the parent entity in all its relationships thus it’s a strong entity.
· Author (AuthorID, fname,lname)
Primary key AuthorID
Author is a strong entity because it is the parent entity in all its relationships. The composite attribute authorName forms fname and lname.
· Publisher (PublisherNumber, publisherName)
Primary key (publisherNumber)
Publisher entity is a strong entity as it is the parent entity in all its relationships.
· Book (ISBN,bookTitle,bookEdition,publicationDate,publisherNumber,categoryCode)
Primary key ISBN
Foreign key publisherNumber references publisher (publisherNumber) ON UPDATE CASCADE ON DELETE NO ACTION
Foreign key categoryCode references category (categoryCode) ON UPDATE CASCADE ON DELETE NO ACTION
Relationship between book and uathors is 1..* which is multivalued and can be form a child table called book_authors. Relationship between publisher and book is 1..1 .publisher has mandatory participation in the book entity thus publisherNumber is set to NOT NULL. UPDATE CASCADE was chosen to update the publisherNumber whenever the attribute value changes in the parent table. DELETE NO ACTION has been selected to stop publisher from being deleted without first updating the book. A book has 1..1 relationship with category. UPDATE CASCADE was chosen to update the CategoryCode whenever the attribute value changes in the parent table. DELETE NO ACTION has been selected to stop the Category from being deleted without first updating the Book.
· Book_authors (ISBN,AuthorID)
Primary key (ISBN, AuthorID)
Foreign key ISBN references Book (ISBN) ON UPDATE CASCADE ON DELETE CASCADE
Foreign key AuthorID references Author (AuthorID) ON UPDATE CASCADE ON DELETE CASCADE
This entity is a weak entity derived from the relationship between book and authors where Book entity 1..* Author. A book has one or more authors thus is multivalued in the Book entity so to eliminate this a child entity is created. Foreign key ISBN is set to NOT NULL because Book has a mandatory participation in Book_authors. UPDATE CASCADE was chosen to update the ISBN whenever the attribute value changes in the parent table. DELETE CASCADE was chosen to delete the ISBN whenever a record is deleted in the parent table. Foreign key AuthorID is set to NOT NULL because Author has a mandatory participation in Book_authors. UPDATE CASCADE was chosen to update the AuthorID whenever the attribute value changes in the parent table. DELETE CASCADE was chosen to delete the AuthorID whenever a record is deleted in the parent table.
· BookCopy (inventoryNumber,price,dateAvailable,ISBN)
Primary key (inventoryNumber)
Foreign key ISBN references Book (ISBN) ON UPDATE CASCADE ON DELETE NO ACTION
The BookCopy entity is a weak entity. Relationship between book and BookCopy is 1..*. UPDATE CASCADE was selected to update ISBN whenever the attribute value changes in the Book table. DELETE NO ACTION has been selected to prevent a book copy from being deleted without first updating the BookCopy entity. Foreign key ISBN is set to NOT NULL because it is mandatory for a bookCopy to be associated with a specific book.
· Category (CategoryCode,description)
Primary Key (CategoryCode, description)
Category entity is the parent entity in all its relationships thus it is a strong entity.
· Invoice (purchaseNumber,dateInvoiced,statusOfPayment, datePaid)
Primary key (purchaseNumber)
Foreign key purchaseNumber references purchase (purchaseNumber) ON UPDATE CASCADE ON DELETE CASCADE
The Invoice entity is a weak entity because it is the child table in its relation with purchase. The relationship between purchase and invoice entity is 1..1 because one purchase results to one and only one invoice. UPDATE CASCADE has been selected to update the purchaseNumbeer whenever the attribute is updated in the purchase entity. DELETE CASCADE has been selected to prevent the invoice record from being deleted if its purchase related record is deleted in the purchase entity.
· Purchase (purchaseNumber,purchaseDate,innventoryNumber, membershipNO)
Primary key (purchaseNumber)
Foreign key inventoryNumber references BookCopy (inventoryNumber) ON UPDATE CASCADE ON DELETE NO ACTION
Foreign key membershipNO references member (membershipNO) ON UPDATE CASCADE ON DELETE NO ACTION
Purchase is a weak entity because it is the child table in its relationship with BookCopy entity and with member entity. The relationship between BookCopy and purchase is 1..1 because a purchase consists of one book. UPDATE CASCADE was chosen to update inventoryNumber whenever the attribute value changes in the BookCopy entity. DELETE NO ACTION has been selected to prevent a BookCopy from being deleted without first updating the purchase entity. inventoryNumber is set to NOT NULL because every purchase has to be associated with a bookCopy.
The relationship between Member entity and Purchase entity is 1..* because a member can make none or more puchases. UPDATE CASCADE has been selected to update the memberNO whenever the attribute is changed in the Member entity. DELETE NO ACTION has been selected to prevent a member from being deleted without first updating the purchase entity.
· Request (requestID,startDate,expiryDate,membershipNO)
Primary key (requestID)
Foreign key membershipNO references Member (membershipNO) ON UPDATE CASCADE ON DELETE NO ACTION
The request entity is a weak entity because it’s the child entity in its relationship with member entity. Member entity has 1..* relationship because a member registers for none or many requests. UPDATE CASCADE has been selected to update the membershipNO whenever the attribute is updated in the member table. DELETE NO ACTION has been selected to prevent a member from being deleted without first updating the purchase entity. membershipNO is set to NOT NULL because every request has to be associated with a member.
· AuthorWatch (WatchNO,authorID)
Primary key (watchNO,authorID)
Foreign key watchNO references watch (watchNO) ON UPDATE CASCADE ON DELETE NO ACTION
FOREIGN KEY authorID references author (authorID) ON UPDATE CASCADE ON DELETE NO ACTION
Authorwatch entity is a weak entity because is a child table in all relationships. Authorwatch has 1..1 relationship with author entity because every author watch nominates one author. ON UPDATE CASCADE has been selected to update the authorID whenever the attribute is updated in the author table. ON DELETE NO ACTION has been selected to prevent an author from being deleted without first updating the AuthorWatch entity.
The relationship between watch and AuthorWatch is optional as a watch can be other types of watches. ON UPDATE CASCADE has been selected to update the watchNO whenever the attribute is updated in the parent table. ON DELETE NO ACTION has been selected to prevent a watch record from being deleted without first updating the authorwatch entity.
· Watch (WatchNO, statusCode, requestID)
Primary key (watchNO)
Foreign key requestNO references request (requestID) ON UPDATE CASCADE ON DELETE NO ACTION.
The watch entity is a weak entity because it is the child entity in its relationship with request. The relationship is 1..* because a request consists of many watches. UPDATE CASCADE has been selected to update the requestID whenever the attribute is updated in the request table. DELETE NO ACTION has been selected to prevent a request from being deleted i without first updating the watch entity. requestID is set to NOT NULL because a watch is associated with a request.
· CategoryWatch (WatchNO,categoryCode, startPublicationYear, endPublicationYear)
Primary key (watchNO,categoryCode)
Foreign key watchNO references watch (watchNO) ON UPDATE CASCADE ON DELETE NO ACTION
FOREIGN KEY categoryCode references Cateogry (CategoryCode) ON UPDATE CASCADE ON DELETE NO ACTION
categoryWatch entity is a weak entity because is a child table in all relationships. CategoryWatch has 1..1 relationship with Category entity because every category watch nominates one category. ON UPDATE CASCADE has been selected to update the categoryCode whenever the attribute is updated in the category table. ON DELETE NO ACTION has been selected to prevent a category from being deleted without first updating the CategoryWatch entity.
The relationship between watch and CategoryWatch is optional as a watch can be other types of watches. ON UPDATE CASCADE has been selected to update the watchNO whenever the attribute is updated in the parent table. ON DELETE NO ACTION has been selected to prevent a watch record from being deleted without first updating the CategoryWatch entity.
· Bookwatch (WatchNO,ISBN)
Primary key (watchNO,ISBN)
Foreign key watchNO references watch (watchNO) ON UPDATE CASCADE ON DELETE NO ACTION
FOREIGN KEY ISBN references Book (ISBN) ON UPDATE CASCADE ON DELETE NO ACTION
Bookwatch entity is a weak entity because is a child table in all relationships. Bookwatch has 1..5 relationship with Book entity because every Book watch nominates 5 Books. ON UPDATE CASCADE has been selected to update the ISBN whenever the attribute is updated in the Book table. ON DELETE NO ACTION has been selected to prevent a Book from being deleted without first updating the Bookwatch entity.
The relationship between watch and Bookwatch is optional as a watch can be other types of watches. ON UPDATE CASCADE has been selected to update the watchNO whenever the attribute is updated in the parent table. ON DELETE NO ACTION has been selected to prevent a watch record from being deleted without first updating the BookWatch entity.
Free Membership to World’s Largest Sample Bank
To View this & another 50000+ free samples. Please put
your valid email id.
Yes, alert me for offers and important updates
Submit
Download Sample Now
Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.
UploadUnique Document
DocumentUnder Evaluation
Get Moneyinto Your Wallet
Total 7 pages
PAY 4 USD TO DOWNLOAD
*The content must not be available online or in our existing Database to qualify as
unique.
Cite This Work
To export a reference to this article please select a referencing stye below:
APA
MLA
Harvard
OSCOLA
Vancouver
My Assignment Help. (2020). Data Modelling Assignment. Retrieved from https://myassignmenthelp.com/free-samples/comp2761-data-modelling-assignment/bookwatch-entity.html.
“Data Modelling Assignment.” My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/comp2761-data-modelling-assignment/bookwatch-entity.html.
My Assignment Help (2020) Data Modelling Assignment [Online]. Available from: https://myassignmenthelp.com/free-samples/comp2761-data-modelling-assignment/bookwatch-entity.html[Accessed 18 December 2021].
My Assignment Help. ‘Data Modelling Assignment’ (My Assignment Help, 2020)
My Assignment Help. Data Modelling Assignment [Internet]. My Assignment Help. 2020 [cited 18 December 2021]. Available from: https://myassignmenthelp.com/free-samples/comp2761-data-modelling-assignment/bookwatch-entity.html.
×
.close{position: absolute;right: 5px;z-index: 999;opacity: 1;color: #ff8b00;}
×
Thank you for your interest
The respective sample has been mail to your register email id
×
CONGRATS!
$20 Credited
successfully in your wallet.
* $5 to be used on order value more than $50. Valid for
only 1
month.
Account created successfully!
We have sent login details on your registered email.
User:
Password:
MyAssignmenthelp.com provides affordable essay help to students in Australia. Being a cheap essay writing service, we aim at providing the best in the minimum. We offer tons of freebies and a good discount for placing orders with us. All our efforts are aimed at ensuring that having a reliable and quality academic assignment help doesn’t drill hole in your pocket. Our writers draft paper from scratch, resourcing updated facts and information to be used in the paper. Exhaustive research resources are at our disposal to draft quality research papers. Some of our popular services include research paper help, dissertation help, thesis help, homework help, coursework help and class-apart works in lot other academic papers.
Latest Management Samples
div#loaddata .card img {max-width: 100%;
}
MPM755 Building Success In Commerce
Download :
0 | Pages :
9
Course Code: MPM755
University: Deakin University
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Australia
Answers:
Introduction
The process of developing a successful business entity requires a multidimensional analysis of several factors that relate to the internal and external environment in commerce. The areas covered in this current unit are essential in transforming the business perspective regarding the key commerce factors such as ethics, technology, culture, entrepreneurship, leadership, culture, and globalization (Nzelibe, 1996; Barza, 2…
Read
More
SNM660 Evidence Based Practice
Download :
0 | Pages :
8
Course Code: SNM660
University: The University Of Sheffield
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: United Kingdom
Answers:
Critical reflection on the objective, design, methodology and outcome of the research undertaken Assessment-I
Smoking and tobacco addiction is one of the few among the most basic general restorative issues, particularly to developed nations such as the UK. It has been represented that among all risk segments smoking is the fourth driving purpose behind infections and other several ailments like asthma, breathing and problems in the l…
Read
More
Tags:
Australia Maidstone Management Business management with marketing University of New South Wales Masters in Business Administration
BSBHRM513 Manage Workforce Planning
Download :
0 | Pages :
20
Course Code: BSBHRM513
University: Tafe NSW
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Australia
Answer:
Task 1
1.0 Data on staff turnover and demographics
That includes the staffing information of JKL industries for the fiscal year of 2014-15, it can be said that the company is having problems related to employee turnover. For the role of Senior Manager in Sydney, the organization needs 4 managers; however, one manager is exiting. It will make one empty position which might hurt the decision making process. On the other hand, In Brisba…
Read
More
MKT2031 Issues In Small Business And Entrepreneurship
Download :
0 | Pages :
5
Course Code: MKT2031
University: University Of Northampton
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: United Kingdom
Answer:
Entrepreneurial ventures
Entrepreneurship is the capacity and willingness to develop, manage, and put in order operations of any business venture with an intention to make profits despite the risks that may be involved in such venture. Small and large businesses have a vital role to play in the overall performance of the economy. It is, therefore, necessary to consider the difference between entrepreneurial ventures, individual, and c…
Read
More
Tags:
Turkey Istanbul Management University of Employee Masters in Business Administration
MN506 System Management
Download :
0 | Pages :
7
Course Code: MN506
University: Melbourne Institute Of Technology
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Australia
Answer:
Introduction
An operating system (OS) is defined as a system software that is installed in the systems for the management of the hardware along with the other software resources. Every computer system and mobile device requires an operating system for functioning and execution of operations. There is a great use of mobile devices such as tablets and Smartphones that has increased. One of the widely used and implemented operating syste…
Read
More
Tags:
Australia Cheltenham Computer Science Litigation and Dispute Management University of New South Wales Information Technology
Next