$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

BN204 Database Technologies

tag 0 Download5 Pages / 1,013 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Questions:

 
1. The snapshot of  MovieDB  database structure is given below. MovieDB  is a database that keeps track of information about the movies, directors, and stars (i.e. actors and actresses) in a video store.
You are working as an IT specialist in this organisation and are required to extract information from this database by executing SQL queries according to the instructions given below.
The primary keys are marked with the key symbol in the following snapshot of MovieDB  database shown in figure 1.


Figure 1: Snapshot of  the MovieDB  database structure

 

Description of the schema
actor – stores details of the actors in the database MovieDB
director – stores details of the directors
movie – keeps track of movie details
genres – stores movie categories, such as action, horror, adventure, drama, romance, comedy

a. First you need to create the above database structure on MS Access and populate all the tables with suitable data (at least 3 records per table) using the following SQL statement or data sheet view in MS Access.
INSERT into TableName
VALUES (“..”,”..”,.....)

b. Write SQL queries (do not use QBE) for the following questions and execute the queries after creating the above database on MS Access.  Include screen shots of the outputs and all SQL statements you used to answer following questions

1. Display details of all movie titles released after 2017. Your result set should be sorted on descending order of the mov_title.
2. List titles of all horror movies.
3. Display movie title, year released of all movies and names of directors who directed them.
4. List titles of movies directed by “James Cameron”.
5. Create a new table named “JamesCameron_MOVIES” that includes titles of movies directed by “James Cameron”.
6. Find actors playing in  movies directed by “James Cameron”.
7. Assume that you want to count how many movies were released after 2017. Write a query to find the number.

2.a. Determine the Functional Dependencies that exist in the following Order table.

Order (OrderNum, OrderDate, Customer_No, Customer_Name, Customer_contactNo,        ItemNum, Description, NumOrdered, QuotedPrice)

b. Normalize the above relation to 3rd normal form, ensuring that the resulting relations are dependency-preserving and specify the primary keys in the normalized relations by underlining them.

c. An agency called WorkForce supplies part-time staff to hotels throughout Australia. The table shown below lists the time spent by agency staff working at two hotels.  The Emp_ID is unique for each employee.

Emp_ID

Contract_No

HoursAssigned

PerWeek

Hotel_contact_No

HotelNo

HotelLocation

1177567

MIT1009

17

045566790

H12

Ringwood

1256788

MIT10010

20

056678954

H40

Melbourne CBD

2246769

MIT10011

30

045566790

H12

Ringwood

2254678

MIT10012

30

056678954

H40

Melbourne CBD

3758956

MIT10013

25

045566790

H12

Ringwood

4237890

MIT10014

36

056678954

H40

Melbourne CBD


Provide examples of insertion and deletion anomalies that may occur in the above table. 

3.a. A data warehouse (DW) is a collection of corporate information and data derived from operational systems and external data sources.  Research more about this topic and find out benefits of using a Data Warehouse for business.

b. Assume that you have been appointed as a database developer in an organisation. Explain briefly, what will be your key responsibilities in the role of a database developer.

c. Explore the job listings advertised online and find out the skills you need to become a database developer.

Cite This Work

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

My Assignment Help (2020) BN204 Database Technologies [Online]. Available from: https://myassignmenthelp.com/free-samples/bn204-database-technologies/responsibilities-in-the-role-of-a-database-developer.html
[Accessed 31 July 2021].

My Assignment Help. 'BN204 Database Technologies' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/bn204-database-technologies/responsibilities-in-the-role-of-a-database-developer.html> accessed 31 July 2021.

My Assignment Help. BN204 Database Technologies [Internet]. My Assignment Help. 2020 [cited 31 July 2021]. Available from: https://myassignmenthelp.com/free-samples/bn204-database-technologies/responsibilities-in-the-role-of-a-database-developer.html.


MyAssignmenthelp.com delivers assignment help to millions of students of USA. We have in-house teams of assignment writers who are experts on wide ranges of subjects. We have appointed teams of native writers who provide assignment help to students in New York City and all over the USA. They are skilled assignment writers who successfully cater to search terms like do my assignment in the USA

Latest Database Samples

INM305 Information Retrieval

Download : 0 | Pages : 15

Answer: Introduction The work is based on the facets which is the web application framework to handle the MVC architecture for the server side. It is able to handle the model for the client as well. The structure of the facet is based on allowing the navigation with the control of the web applications as well. (Anagnostopoulos  et l., 2016). It will help in providing the client side that will be for the development of the rich web a...

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

CSE 544 Principles Of Database Systems

Download : 0 | Pages : 7

Answer: Purpose The purpose of this document is to focus on enhancement of the business of Yebhi.com. The company has been facing issues with the online ordering system. The company is not sure of the resources available, or the products available which are ordered by the customers. The goal is to design a system that would enhance the business of the company, along with giving them a clear picture of the availability of the resources (Al-Qei...

Read More arrow

ITC544 Computer Organisation And Architecture

Download : 0 | Pages : 3

Answers: A1 a) To calculate x if (211)x = (6A)16 ...(1) RHS We will convert RHS into decimal number system. (6A)16 = (6 * 161) + (10 * 160) (A16 = 1010) = (6 * 16)  + (10 * 1) (a1 = a), (a0 = 1) = 96 + 10 = 106 ...(2) LHS We will expand LHS into decimal number system. Since the base is unknown, we will continue with the variable for the time being. (211)x = (2 * x2) + (1 * x1) + (1 * x0) = (2x2)  ...

Read More arrow

COIT20249 Professional Skills In Information Communication Technology

Download : 0 | Pages : 2

Answer: Critical thinking is the need for the era to identify the difference between belief and knowledge. Critical thinking is defined by different personalities of academics in different language with almost same meaning. Richard Arum, the sociology professor of New York University has defined critical thinking as the ability, which can be able to make cross-examination of evidence, and respective arguments, which seems to be logical to just...

Read More arrow Tags: Australia Box Hill Management Please note this assignment consists of questions from Horngren  C.T.  Sundem  G.L.  Stratton  W.O.  Universit 

COIS 12036 Human Computer Interaction

Download : 0 | Pages : 4

Answer: Museum of Science and Technology outsourced development of a website to an IT firm. The purpose of the website was to showcase the items available in the museum and provide information about the facility including operating hours, location, and fees charged. After completing the previous project phases, we are now at the last stage of the project. This stage involves incorporating feedback provided in the last phases to refine the pro...

Read More arrow
Next

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
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

Order on the go!

Say hello to our new app

callback request mobile
Have any Query?