fb
$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
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.

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

250 words

Error goes here

Students Who Viewed This Also Studied

9 Pages
FIT9132 Introduction to Databases

TASKS1. Using LucidChart, prior to completing task 2 (the normalisation), prepare an initialconceptual model (Entity Relationship Diagram) for Run Monash (RM). For this initialconceptual model, only i ...

Type

Programming

Subject

Database

15 Pages
Entity-Relationship Diagrams (ERD)

Part A — Entity-Relationship Diagrams                            &nbs ...

Type

Programming

Subject

Database

36 Pages
SDLC

Assessment item 2 Elaboration phase Value: 40% Due date: 16-Sep-2016 Return date: 13-Oct-2016 Submission method options Alternative submission method Task In this assessment item, you are required to ...

Type

Programming

Subject

Database

5 Pages
Management

Business Section… 1.) Explain what the business is that hired you to develop a database (1-3 paragraphs) 2.) Provide a brief description of the problem that the business has (1-3 paragraphs) ...

Type

Programming

Subject

Database

COMP2400 Relational Databases

Question

Answered

Question

1.

The relational database moviedb has the following database schema:

Movie(title, production year, country, run time, major genre)

primary key : ftitle, production yearg

Person(id,  rst name, last name, year born)

primary key : fidg

Award(award name, institution, country)

primary key : faward nameg

Restriction Category(description, country)

primary key : fdescription, countryg

Director(id, title, production year)

primary key : ftitle, production yearg

foreign keys : [title, production year] Movie[title, production year] [id] Person[id] 

Writer(id, title, production year, credits)

primary key : fid, title, production yearg

foreign keys : [title, production year] Movie[title, production year] [id] Person[id]

Crew(id, title, production year, contribution)

primary key : fid, title, production yearg

foreign keys : [title, production year] Movie[title, production year] [id] Person[id]

Scene(title, production year, scene no, description) primary key : ftitle, production year, scene nog

foreign keys : [title, production year] Movie[title, production year]

Role(id, title, production year, description, credits) primary key : ftitle, production year, descriptiong

foreign keys : [title, production year] Movie[title, production year] [id] Person[id]

Restriction(title, production year, description, country)

primary key : ftitle, production year, description, countryg

foreign keys : [title, production year] Movie[title, production year]

[description, country] Restriction Category[description, country]

Appearance(title, production year, description, scene no)

primary key : ftitle, production year, description, scene nog

foreign keys : [title, production year, scene no] Scene[title, production year, scene no] [title, production year, description] Role[title, production year, description]

Movie Award(title, production year, award name, year of award,category, result) primary key : ftitle, production year, award name, year of award, categoryg foreign keys : [title, production year] Movie[title, production year]

[award name] Award[award name]

Crew Award(id, title, production year, award name, year of award, category, result) primary key : fid, title, production year, award name, year of award, categoryg foreign keys : [id, title, production year] Crew[id, title, production year]

[award name] Award[award name]

Director Award(title, production year, award name, year of award, category, result) primary key : ftitle, production year, award name, year of award, categoryg foreign keys : [title, production year] Director[title, production year]

 [award name] Award[award name]

Writer Award(id, title, production year, award name, year of award, category, result) primary key : fid, title, production year, award name, year of award, categoryg foreign keys : [id, title, production year] Writer[id, title, production year]

[award name] Award[award name]

Actor Award(title, production year, description, award name, year of award,category,result) primary key : ftitle, production year, description, award name, year of award, categoryg foreign keys : [award name] Award[award name]

[title,production year,description]  Role[title,production year,description]

There are ve di erent categories of awards: movie awards, crew awards, director awards, writer awards and actor awards. A movie can only win an award after being nominated for the award.

Your task is to answer the following questions using SQL queries. For each question, your answer must be a single SQL query that may contain subqueries, and you must write and save your queries into the template le myqueries.sql.

1.1 Which awards are there in USA? List these award names.

1.2 Which comedy movies (i.e., the major genre of the movie is comedy) were produced in 1994? List their titles.

1.3 Who played at least one role in movies produced in 1995? List their ids,  rst and last names.

1.4 How many directors have directed at least one movie written by themselves? List that number.

1.5 Which movies had the ‘PG’ restriction in at least two countries? List their titles, production years and the corresponding number of countries with the ‘PG’ restriction.

1.6 Who have written exactly two American movies (i.e., the production country is USA)? List their ids,  rst and last names. Order your results in the ascending order of their ids.

1.7 How many directors have never played any roles in movies directed by themselves? List that number.

1.8 Which crew member(s) worked on the greatest number of movies? List their id(s),  rst and last names.

1.9 Who received the greatest number of nominations for a writer award but never won? List their id(s). 

1.10 Find all the pairs of crew members who won a crew award at the same age. List the pairs of their ids. Note that the result should not contain duplicated pairs of ids, e.g., (id1, id2) and (id2, id1) are considered as duplicated pairs and your query should only produce one of them in the result. Hint: if Emily (born in 1960) won a crew award in 1995 and Tom (born in 1955) won a crew award in 1990, they are considered as a pair of crew members who won a crew award at the same age (=35).

COMP2400 Relational Databases

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

29 More Pages to Come in This Document. Get access to the complete answer.

With a pool of 3000+ homework helper, MyAssignmenthelp.com has been successfully providing homework help services for over a decade now. We have become the best homework solver online with years of experience in academic writing. Our experts have played a vital role behind our overwhelming success. Their knowledge and commitment to provide high quality homework assistance has gained us the status of best homework help provider in this industry. Our services have satisfied the needs of many students so far who often search can someone write my homework online.

More COMP2400 COMP2400 Relational Databases: Questions & Answers

Q

TASKS1. Using LucidChart, prior to completing task 2 (the normalisation), prepare an initialconceptual model (Entity Relationship Diagram) for Run Monash (RM). For this initialconceptual model, only include what you see as identifiers (keys) for each entity , do notinclude other attributes at this s ...

View Answer
Q

Part A — Entity-Relationship Diagrams                                (50 marks) Draw an Entity-Relationship Diagram (ERD) for the data storage requirement ...

View Answer
Q

Assessment item 2 Elaboration phase Value: 40% Due date: 16-Sep-2016 Return date: 13-Oct-2016 Submission method options Alternative submission method Task In this assessment item, you are required to provide the detailed architecture and design of the system presented in Assessment Item 1 in report ...

View Answer
Q

Business Section… 1.) Explain what the business is that hired you to develop a database (1-3 paragraphs) 2.) Provide a brief description of the problem that the business has (1-3 paragraphs) 3.) Provide a series of specifications that the business needs 4.) Provide at least 8 reports that ...

View Answer

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.

Choose Our Best Expert to Help You

expert
student rating student rating student rating student rating student rating
Marcel Newman

Master’s degree in Law from Columbia University

600 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Samuel Callaway

Master's in Ancient History

9 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Iker Huber

PhD in Civil Engineering

1211 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Albert Stevenson

I have completed my PhD in Literature from the University of Birmingham

110 - Completed Orders

Hire Me

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

student rating student rating student rating student rating student rating
04 Dec 2021

It Write Up

Essay: 2 Pages, Deadline: 22 hours

expert finish the assignment on the time. Looks the assignment meet the requirement as per my request.

flag User ID: 5***87 Malaysia

student rating student rating student rating student rating student rating
03 Dec 2021

Marketing

Assignment: 12 Pages, Deadline: 2 days

very very good. also very willing to help out with escalations and reviewing the assignment for me.

flag User ID: 8***21 Singapore

student rating student rating student rating student rating student rating
03 Dec 2021

Marketing

Assignment: 6 Pages, Deadline: 7 days

The assignment provided was great. i had given one less start because the assignment is still not graded

flag User ID: 8***14 Mississauga, Canada

student rating student rating student rating student rating student rating
03 Dec 2021

Assignment

Essay: 2 Pages, Deadline: 4 days

Hi Thank you so much for your help today i got very high score I am so happy thanks again

flag User ID: 2***93 Melbourne, Australia

student rating student rating student rating student rating student rating
03 Dec 2021

Economics

Assignment: 4 Pages, Deadline: 13 days

I just got my result published today. I scored a pretty good mark on this assignment.

flag User ID: 5***78 Australia

student rating student rating student rating student rating student rating
03 Dec 2021

Management

Thesis: 1 Page, Deadline: 5 days

great job I was very satisfied all went through without any problems, thank you so much for your help

flag User ID: 6***06 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
03 Dec 2021

Assignment

Essay: 1 Page, Deadline: 19 days

Writer did a great job. Very informative and thorough. Very Impressive. Thank you.

flag User ID: 7***39 United States

student rating student rating student rating student rating student rating
03 Dec 2021

Statistics

Programming: 2 Pages, Deadline: 1 hour

I am very Satisfied with the help I received. I Highly recommend them for any study help

flag User ID: 2***79 Pawtucket, United States

student rating student rating student rating student rating student rating
03 Dec 2021

Management

Essay: 5 Pages, Deadline: 21 days

It is a good writing with reliable sources and meet the deadline earlier than I expected. Such a good job

flag User ID: 5***30 Canada

student rating student rating student rating student rating student rating
03 Dec 2021

Mechanical Engineering

Home Work: 1 Page, Deadline: 27 days

Made a 69% but worked really hard! I think the option for 2 experts should be available.

flag User ID: 6***06 Atlanta, United States

student rating student rating student rating student rating student rating
04 Dec 2021

It Write Up

Essay: 2 Pages, Deadline: 22 hours

expert finish the assignment on the time. Looks the assignment meet the requirement as per my request.

flag User ID: 5***87 Malaysia

student rating student rating student rating student rating student rating
03 Dec 2021

Marketing

Assignment: 12 Pages, Deadline: 2 days

very very good. also very willing to help out with escalations and reviewing the assignment for me.

flag User ID: 8***21 Singapore

student rating student rating student rating student rating student rating
03 Dec 2021

Marketing

Assignment: 6 Pages, Deadline: 7 days

The assignment provided was great. i had given one less start because the assignment is still not graded

flag User ID: 8***14 Mississauga, Canada

student rating student rating student rating student rating student rating
03 Dec 2021

Assignment

Essay: 2 Pages, Deadline: 4 days

Hi Thank you so much for your help today i got very high score I am so happy thanks again

flag User ID: 2***93 Melbourne, Australia

student rating student rating student rating student rating student rating
03 Dec 2021

Economics

Assignment: 4 Pages, Deadline: 13 days

I just got my result published today. I scored a pretty good mark on this assignment.

flag User ID: 5***78 Australia

student rating student rating student rating student rating student rating
03 Dec 2021

Management

Thesis: 1 Page, Deadline: 5 days

great job I was very satisfied all went through without any problems, thank you so much for your help

flag User ID: 6***06 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
03 Dec 2021

Assignment

Essay: 1 Page, Deadline: 19 days

Writer did a great job. Very informative and thorough. Very Impressive. Thank you.

flag User ID: 7***39 United States

student rating student rating student rating student rating student rating
03 Dec 2021

Statistics

Programming: 2 Pages, Deadline: 1 hour

I am very Satisfied with the help I received. I Highly recommend them for any study help

flag User ID: 2***79 Pawtucket, United States

student rating student rating student rating student rating student rating
03 Dec 2021

Management

Essay: 5 Pages, Deadline: 21 days

It is a good writing with reliable sources and meet the deadline earlier than I expected. Such a good job

flag User ID: 5***30 Canada

student rating student rating student rating student rating student rating
03 Dec 2021

Mechanical Engineering

Home Work: 1 Page, Deadline: 27 days

Made a 69% but worked really hard! I think the option for 2 experts should be available.

flag User ID: 6***06 Atlanta, United States

5% Cashback

On APP - grab it while it lasts!

Download app now

*Offer eligible for first 3 orders ordered through app!

ribbon
callback request mobile
Have any Query?