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

Error goes here

COM4003 Database Design

tag 0 Download16 Pages / 3,918 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Question:

Develop a semantically rich data model that captures the above scenario in the form of an entity-relationship diagram (ERD). You should note (and number) all assumptions you make about the data and the reasoning behind your design choices. Also, include (and number) any appropriate constraints and a list of entity types showing their attributes and identifiers.

Question 2
Once you are satisfied that the ER diagram is a good representation of the organisation’s data requirements, produce a logical design by mapping the ER diagram to a set of normalised relations – to third normal form (3NF). You should annotate and explain this process.

Question 3
Take each of the normalised relations and implement them as SQL tables using an appropriate DBMS – such as Oracle, MySQL or another one you have access to – and a series of CREATE TABLE statements. You must include all primary and foreign keys as well as any other table or column constraints you feel are appropriate such as NOT NULL,
CHECK, UNIQUE and DEFAULT. Provide screenshots of the working code. Ensure your user name or some other distinguishing aspect is included in the screenshot to verify it is your code.

Question 4
Using appropriate sample data and your own imagination based on this case study, populate your finished tables with at least 10 rows of data in each table. Provide screenshots of the working code. When done, display the full contents of each populated table to screen and take screenshots. Ensure your user name or some other distinguishing aspect is included in the screenshot to verify it is your code.

Question 5
To demonstrate that your final database is useful, write a set of realistic sample SQL queries based on the above scenario (use your imagination for details of each query) but they should include the following techniques:
• SELECT…FROM…WHERE…
• Joins (using two, three or more tables)
• Ordering output (ORDER BY)
• Grouping output (GROUP BY)
• Aggregate functions (MIN, MAX, AVG, COUNT, SUM)

You should aim to write at least ten sample queries – ranging from basic SELECT…FROM…WHERE queries to more advanced ones using the above techniques. Be sure to fully evidence all SQL work by taking screenshots of the inputted code and the outputted results. Ensure your user name or some other distinguishing aspect is included in
the screenshot to verify it is your code.
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 16 pages, 1 USD Per Page

Cite This Work

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

My Assignment Help. (2021). Database Design. Retrieved from https://myassignmenthelp.com/free-samples/com4003-database-design/more-items.html.

My Assignment Help (2021) Database Design [Online]. Available from: https://myassignmenthelp.com/free-samples/com4003-database-design/more-items.html
[Accessed 22 April 2021].

My Assignment Help. 'Database Design' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/com4003-database-design/more-items.html> accessed 22 April 2021.

My Assignment Help. Database Design [Internet]. My Assignment Help. 2021 [cited 22 April 2021]. Available from: https://myassignmenthelp.com/free-samples/com4003-database-design/more-items.html.


Get a conclusive summary, detailed notes, annotations, informative intro paragraphs, descriptions of setting, summary of the plot and lot more with our book report writers. Our book report writers let you know how to write a report to get positive reviews and better critics. Connect with our book report writers to create impactful book report, so that your readers and faculty appreciates it. Our reports are the best analysis of what the book intends to deliver to the readers and how far they have been sucessful. Also learn how to write a book review with us. Connect with us now.

Latest Database Samples

CSE 283 Data Communications And Networks

Download : 0 | Pages : 3

Answer A USB Type-C connection is a port which is available on the MacBook which has mandatory headphone jack; it is responsible for taking care of power, data transfers and display output. Thunderbolt was developed with a promise of leaving behind the USB ports. Because according to the developers of Intel and Apple it was must fatter and the data transfer rate was faster than USBs (Intel, 2015). Along with this, it helps users to connect to ...

Read More arrow

ITECH3224 WWW Technology

Download : 0 | Page : 1

Answer: The database given was normalized to achieve a better database. Normalization of the database involved following the following steps; Ensuring no entity has any repeating groups to normalize the relations to 1NF. Ensuring all entities achieved as a result of normalization to 1NF have no partial dependencies thus normalizing them to 2NF. This involves making sure that an entity has only one candidate key that the other keys depend o...

Read More arrow

CSC72001 Database Systems

Download : 0 | Pages : 4

Answer:   The database should be able to store the details of all the courses in the system and each course in the system should be identified with a unique identity that would be helpful in distinguishing the different entries in the tables. The database should be able to store the details of all the students each data should be identified by a unique identification key. The database should be able to store the details of the enro...

Read More arrow

ENG4195 Systems Analysis And Design

Download : 0 | Pages : 6

Answer: Part 1: Use Case Realisation for the ‘Record New Tour’ Use Case 1.1 Analysis Class Diagram:  In the paradigm of software engineering, the class diagram is a part of UML that represents the static structure of an application. The class diagram, as the name suggests, represents the classes of the application. These classes has attributes and operations. The class diagram are mainly used for describing the element...

Read More arrow

ICT701 Relational Database Systems

Download : 0 | Pages : 2

Answer: Assumption: - A APPLIED_STAFF has many QUALIFICATION_DETAIL and a QUALIFICATION_DETAIL is related to many APPLIED_STAFF. Here many too many relationships occur. So I create a new table that is STAFF_QUALIFICATION. Here a staff has one or many STAFF_QUALIFICATION and each STAFF_QUALIFICATION is related to one and only one APPLIED_STAFF. A qualification is related to one or many STAFF_QUALIFICATION and each STAFF_QUALIFICATION is ...

Read More arrow
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,659,221

Orders

4.9/5

Overall Rating

5,122

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 5/5

453 Order Completed

98% Response Time

Howard Asuncion

LLM in Criminal Law

London, United Kingdom

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

203 Order Completed

97% Response Time

Richard Alpert

PhD in Psychology

London, United Kingdom

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

647 Order Completed

98% Response Time

Adlina Han

Masters in Marketing with Specialization in Branding

Singapore, Singapore

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

1309 Order Completed

100% Response Time

Gemmie Chen

MSc in Nursing

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

received 72 marks this is first assignment which i have received above 70 i have given so many assignment after this i received a good marks. but expected is 75 above as i had paid too much money.

flag

User Id: 126036 - 22 Apr 2021

Australia

student rating student rating student rating student rating student rating

received 74 marks this is first assignment which i have received above 74 i have given so many assignment after this i received a good marks. but expected is 85 above as i had paid too much money.

flag

User Id: 126036 - 22 Apr 2021

Australia

student rating student rating student rating student rating student rating

received 69 marks this is first assignment which i have received above 69 i have given so many assignment after this i received a good marks. but expected is 75 above as i had paid too much money.

flag

User Id: 126036 - 22 Apr 2021

Australia

student rating student rating student rating student rating student rating

Literally a life saver with everything going on. It was my first time seeking for assignment help and was really pleased. I definitely will recommend to others and use this platform again.

flag

User Id: 676540 - 22 Apr 2021

Australia

student rating student rating student rating student rating student rating

Order on the go!

Say hello to our new app

callback request mobile
Have any Query?