New

Learn smart - Learn online. Upto 80% off on courses for a limited time. View Courses

Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

CIS2002 Database Design And Implementation

tag 0 Download 5 Pages / 1,035 Words tag 24-10-2020

Questions:

1.

1.An ER diagram for the system. Show all entities, relationships, cardinalities and optionalities. Also, include all intersection entities. You must use the Finkelstein methodology as per the study book and tutorials.

2.A list of relations (equivalent to Finkelstein entity list). Produce complete relations for all entities and attributes. Show all primary and foreign keys. Include all attributes that are specifically mentioned and all key attributes. You may need to create primary and foreign keys that are not specifically mentioned. You must use the Finkelstein methodology as per the study book and tutorials.

3.An Oracle SQL table create statement for the relation that you think is most critical in this system. This relation must have a primary key and at least one foreign key. 

2.

1.Produce a set of relations (equivalent to the Finkelstein entity list) in third normal form (3NF) from the following un-normalised relation. Show your working and entities for 1NF, 2NF and 3NF. You must use the Finkelstein methodology as used in the study book and tutorials.

3.

  • Display the category, book title, retail cost (formatted as $XXX.XX) and gift details for all books which are eligible for a gift. Order the result by category and retail cost (retail cost in descending order)
  • Display the last name, first name, order number for all customers who have placed an order for which they have not received a free gift of “BOOK LABELS” listed in the promotion table. Here we want to use the amount that they paid for each item to see is they were eligible for a gift of “BOOK LABELS”.  The gifts are only available for the price paid and does not take into consideration the quantity of a book purchase.
  • Display the unique customer number, customer last name, customer first name for all customers who have bought a book that was co-authored by more than 2 authors. Order the resulting set by customer number.
  • Display the book title and the publisher name of all the books that have been written by a single author and where that book has had no sales recorded.
  • Display the publisher name, contact details and phone number for all the publisher that have had sales of more than 5 book from the list of books they publish.

  • Display the state, count of number of orders (rename the field “Number of Orders”), and the number of book categories (rename the field “Number of Categories”) for all states that have the number of book categories same as the highest number of book categories in all the states.  We are looking for states that buy the most diverse categories of books.       
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.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 5 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). Database Design And Implementation. Retrieved from https://myassignmenthelp.com/free-samples/cis2002-database-design-and-implementation/entity-relationship-with-customer.html.

My Assignment Help (2020) Database Design And Implementation [Online]. Available from: https://myassignmenthelp.com/free-samples/cis2002-database-design-and-implementation/entity-relationship-with-customer.html
[Accessed 26 June 2022].

My Assignment Help. 'Database Design And Implementation' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/cis2002-database-design-and-implementation/entity-relationship-with-customer.html> accessed 26 June 2022.

My Assignment Help. Database Design And Implementation [Internet]. My Assignment Help. 2020 [cited 26 June 2022]. Available from: https://myassignmenthelp.com/free-samples/cis2002-database-design-and-implementation/entity-relationship-with-customer.html.


In every academic paper, irrespective of its kinds, you are required to write a summary. Most often students fail to comprehend all the points in limited number of words and hence create an incomplete summary. Sometimes they emphasise more on irrelvant points making the summary a bit deficient. We highlight, jot down and intensively research your papers to find points that can make your summary conclusive reference of all the arguments in papers. We have helped students ace grades with excellent summaries for reports, thesis, essays, dissertations and so on.

Latest Database Samples

COMP3340 Data Mining

Download : 0 | Pages : 3

Answer: Introduction The project is about the data analysis using the data mining tool called Weka. The arff file is created using the text editor and analysis is performed on the created arff file. The data of the assessment results of 40 students is taken with 5 attributes namely Assignment1, assignment2, assignment3, assignment4 and Final Exam marks. Creation of Arff File The Arff file is the Attribute Related File Format. This is the fo...

Read More arrow

ED5880 Educational Leadership

Download : 0 | Pages : 12
  • Course Code: ED5880
  • University: James Cook University
    icon

    MyAssignmentHelp.com is not sponsored or endorsed by this college or university

  • Country: Australia

Answer:  Introduction Leadership is a very essential quality that is required to carry forward the ownership of a successful organization. For people who hold a firm post in any organization, it is very essential to have a set of pre-decided rules and codes of conducts that they can implement in order to run the organization better. It is for the leader’s discipline as well as the employee’s, because the leader is accountable...

Read More arrow Tags: Australia Slacks Creek Management James Cook University 

CSE490K Computer Security

Download : 0 | Pages : 12
  • Course Code: CSE490K
  • University: University Of Washington
    icon

    MyAssignmentHelp.com is not sponsored or endorsed by this college or university

  • Country: United States

Answer Security Breaches Introduction There has been a huge development in the technological field in the recent times. There has also been a huge development in the field of internet technologies. With the improvement in the different type of technologies there have also been concerns that are raised in the recent times. In addition to this, there have also been various types of security breaches and data hazards that have been reported i...

Read More arrow

COIT20247 Database Design And Development

Download : 0 | Pages : 3

Answer: Normalization Relations Client (ClientID, FullName, Address, Phone, Level)    Car (RegNo, ClientID, Model, Maker, Color, ProducedYear, CarPrice, WarrantyPeriod) Service (JobNo, Description, ServiceDate, TotalCost) EmployeeType (EmployeeTypeID, Type, Desc) Employee (EmployeeID, FullName, Address, Phone, EmployeeTypeID) LabourWork (EmployeeID, JobNo, StartTime, FinishTime, LabourCost) Complaint (ComplaintID, JobNo, R...

Read More arrow Tags: Australia Cocoroc Humanities WTO dispute resolution and the trade policy review mechanism (GATT/WTO Law) University of New South Wales Manag 

1COMP9120 Database Management Systems

Download : 0 | Pages : 4

Answer: Entity Relationship Diagram Figure 1: Entity Relation Diagram Assumptions To model the relations, the following assumptions were added to the existing business rules to add more clarity in those business rules that were not very clear. A sponsor can give many sponsorships to the club in one season. Thus, the sponsorships brought by the sponsor are recorded in the sponsorships table. A club can have many sponsors in one season ...

Read More arrow Tags: Australia Wentworthville Computer Science Develop an ER Diagram University of Queensland Engineering 
Next

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?