country
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

CIS2002 Database Design And Implementation

tag 0 Download5 Pages / 1,035 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT
  • Course Code: CIS2002
  • University: University Of Southern Queensland
  • Country: Australia

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, 1 USD Per Page

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 24 November 2020].

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 24 November 2020.

My Assignment Help. Database Design And Implementation [Internet]. My Assignment Help. 2020 [cited 24 November 2020]. 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

NIT5130 Database Analysis And Design

Download : 0 | Page : 1
  • Course Code: NIT5130
  • University: Victoria University
  • Country: Australia

Answer: Suppose director inputs 3. Then the details of job of the student with id 3 will appear in the screen. If the director changes any data then clicks submit. Then the job and roster will be updated. Suppose the student wants to be waiter on 13th Feb.The data is also inserted in the student entity of the database. Student Address Report: The address of all the students will appear at screen when the page will be opened.See the last en...

Read More arrow

CS365 Data-mining And Application Empowerment

Download : 0 | Page : 1
  • Course Code: CS365
  • University: University Of Waterloo
  • Country: Canada

Answer: REATE TABLE VCFInfo( AF_ESP FLOAT, AF_EXAC FLOAT,AF_TGP FLOAT, ALLELEID INT, CLNDN varchar2(500),CLNDNINCL varchar2(500),CLNDISDBvarchar2(500),CLNDISDBINCLvarchar2(500),CLNHGVS   varchar2(500),CLNREVSTAT varchar2(500),CLNSIG varchar2(500),CLNSIGCONF varchar2(500),CLNSIGINCL varchar2(500),CLNVC varchar2(500),CLNVCSO varchar2(500),   CLNVI varchar2(500),DBVARID varchar2(500),GENEINFO varchar2(500),MC varchar2(500),ORIGIN varc...

Read More arrow

COMP20010 Data Structures And Algorithms I

Download : 0 | Pages : 4

Answer: The Linear Search Algorithm Linear search is a very commonly used searching method used by most programmers in order to search through a small list of elements. This kind of searching technique is also known as the Sequential Searching algorithm. It is an extremely simple searching algorithm, where a sequential search is conducted over all items in a list or array, one at a time. Every element is checked for equality with the being se...

Read More arrow

ISYS617 Data And Information Management

Download : 0 | Pages : 2
  • Course Code: ISYS617
  • University: Australian Institute Of Higher Education
  • Country: Australia

Answer:   Activity(ActivityID, ActivityName,ActivityDescripion) Primary Key ActivityID   ApprovedStaffSubjects(StaffID, SubjectID) Composite Primary Key StaffID, SubjectID Department(DepartmentID, DepartmentName) Primary Key DepartmentID Employeeeduback(EmployeeID, HighestEduAtt,Qualification, YearCompleted, School) Unique Key EmployeeID EmployeeInfo(EmployeeID, TitleID, FirstName,&...

Read More arrow

ISYS1055 Database Concepts

Download : 0 | Page : 1
  • Course Code: ISYS1055
  • University: Australian Institute Of Higher Education
  • Country: Australia

Answer: 1.1) Functional dependency (FDs): - Doc-rego-> {doc-forstname, doc-surname, doc-gender, doc-qualificatio} Pat-ID->{pat-givename, pat-surname, pat-gender, pat-dob, pat-addr, pat-phone} App-ID-> { Doc-rego, pat-ID, app-datetime, app-type} 1.2)          Candidate keys for the ABC relation and develop the closure for each candidate key you have discovered: - Candidate keys: - Ap...

Read More arrow Tags: Australia Altona Management Accounting theory and accountability University of New South Wales 
Next

Save Time & improve Grade

Just share requirement and get customized Solution.

watch
question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Add File

Error goes here

1,498,900

Orders

4.9/5

Overall Rating

5,100

Experts

Our Amazing Features

delivery

On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

work

Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

time

24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.

subject

Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

price

Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 4/5

3076 Order Completed

99% Response Time

Emily Wei

Doctor of Philosophy (Ph.D) in Civil Engineering

Singapore, Singapore

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

2830 Order Completed

97% Response Time

Leroy Bicknell

MBA in Marketing

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

755 Order Completed

95% Response Time

Douglas Cowley

Masters in Finance with Specialization in Audit

Wellington, New Zealand

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

2115 Order Completed

97% Response Time

Kimberley Chen

MPA in Accounting

Singapore, Singapore

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

calculator

Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

it was really helpful. i got my asssignment on time even before the deadline.it was written really well i am glad that I came to Myassignmenthelp.

flag

User Id: 401534 - 24 Nov 2020

Australia

student rating student rating student rating student rating student rating

very professional i got it before the due time i set, the sheet that was sent to me was very neat and very well done.

flag

User Id: 551988 - 23 Nov 2020

Australia

student rating student rating student rating student rating student rating

Great work! Really appreciate the help and efficiency. Very well organized. Thank you for your help.

flag

User Id: 522859 - 23 Nov 2020

Australia

student rating student rating student rating student rating student rating

given on time. well presented. and very helpful, trust these guys for all your work

flag

User Id: 142836 - 23 Nov 2020

Australia

student rating student rating student rating student rating student rating
callback request mobile
Have any Query?