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

6 Pages
Influence of Business Ethics

 Task Description: Articulate in writing what values you would voice and how you would enact your moral values with respect to an allocated voice to values case. You must also identify the emotio ...

Type

Assignment

Subject

4 Pages
Responsive Web Design (RWD)

Design the type hierarchy for your web site. Create a type specification HTML5 page that shows examples of the different typefaces and sizes and how they will be used. This can be a mock-up page that ...

Type

Assignment

Subject

2 Pages
Australian Industrial Relations Pamphlet

Pamphlet, wich explains a specific industrial relations issue, from the position/point of view of one stakeholder, a government, company,or party ie.agency, a company, a trade union, an employer, asso ...

Type

Assignment

Subject

37 Pages
Wetland systems

Assessment Item 2: Review of the Effectiveness of Constructed Wetlands for the Treatment of either Municipal Wastewater or Urban Stormwater. Assessment Item 2: Review of the Effectiveness of Con ...

Type

Thesis

Subject

Database Technology

Question

Answered

You have been assigned to a University Research Centre to undertake an information systems project that requires you to design and create a database for the Centre Director, Professor Burton. The Centre Director must report to the University on the projects being undertaken, the grants that are financing those projects and the activity of the research staff. Professor Burton would also like to know how many researchers identify with the different areas of excellence recognised by the research centre, how many journal publications are associated with each project and the researchers who author those publications.

Currently the research centre has 20 research staff, 5 areas of excellence (sustainability, accounting history, management accounting, information systems and financial accounting). Some researchers have several areas of interest and others have only one.

Each project requires funding in the form of grants. Each grant is associated with only one research project and each grant is provided by a single sponsor. The Director only wants to record sponsors who have existing grants with projects because he wants to send emails to them and have their other contact details available. The amount of each grant should also be recorded.

The output from each project is a report to the sponsor but it is also expected that the researchers (one or more) will author other research papers that will be published in academic journals.

Professor Burton needs to be able to answer the following questions.

Who are the researchers associated with each research area of excellence?

How many publications have been generated by the research centre and how many have come out of each project?

Which publications has each researcher authored or co-authored?

How much grant money is associated with each project, who is the sponsor and how much has the research centre raised in grants overall?

Required

Create a Research Centre Database for Professor Burton. You will need to produce an entity relationship diagram using the MS Access relationship tool. To do this you will need to determine each of the entities and their attributes. (Take care to choose appropriate primary keys).

Populate the tables with fictitious data. Provide eight projects and 15 publications and the other data according to the information provided.

 

Generate queries to provide Professor Burton with the information he requires. Also provide a list of queries indicating the query name, what information the query provides and the purpose that it serves. This description will be used by Professor Burton to choose the most suitable query for his needs.          

Database Technology

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.

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

MyAssignmenthelp.com strives to deliver quality content to students of USA and deliver assignment writing services as per individual assignment assistance. We have built up a pool of 3800+ assignment experts who provide academic writing help in more than 100+ subjects. Our skilled and experienced assignment writers deliver custom-made assistances, and they offer need-based university assignment help to students as per their assignment demands.

More Database Technology: Questions & Answers

Q

 Task Description: Articulate in writing what values you would voice and how you would enact your moral values with respect to an allocated voice to values case. You must also identify the emotional, cognitive, cultural, political, and institutional “enablers” and “disablers&r ...

View Answer
Q

Design the type hierarchy for your web site. Create a type specification HTML5 page that shows examples of the different typefaces and sizes and how they will be used. This can be a mock-up page that uses generic content but demonstrates the overall typographic scheme. Consider the following questio ...

View Answer
Q

Pamphlet, wich explains a specific industrial relations issue, from the position/point of view of one stakeholder, a government, company,or party ie.agency, a company, a trade union, an employer, association, etc Please see attached files, and include all References from the list, and please Harvard ...

View Answer
Q

Assessment Item 2: Review of the Effectiveness of Constructed Wetlands for the Treatment of either Municipal Wastewater or Urban Stormwater. Assessment Item 2: Review of the Effectiveness of Constructed Wetlands for the Treatment of either Municipal Wastewater or Urban Stormwater. Maximum ...

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
Wilbert Clymer

PhD in Mechanical Engineering with specialization in Energy Science and Technology

3335 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Colleen Lanclos

MBA with Specialization in Marketing

1827 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Maxwell West

Master of Psychology with Specialization in Neuropsychology

1490 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Gilbert Brockett

MBA in Accounting

1171 - 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
02 Dec 2021

English

Essay: 4 Pages, Deadline: 9 days

Very good paper, included everything and helpful. I got a grade on the essay, received a 100 on my paper. I highly recommend this website!

flag User ID: 6***89 United States

student rating student rating student rating student rating student rating
02 Dec 2021

Marketing

Assignment: 10 Pages, Deadline: 11 days

Excellent job. Very timely. Customer service was top-notch. Even my lecturer was impressed.

flag User ID: 8***83 Canada

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Assignment: 7 Pages, Deadline: 9 days

I am very happy when I get marks I feel very verry good I got good marks thank u so much for helping me

flag User ID: 5***67 Canada

student rating student rating student rating student rating student rating
02 Dec 2021

Project Management

Essay: 9 Pages, Deadline: 1 day

was a part of my programme management curs level 5 i passed it with 85% and that is soo good for me, thank you

flag User ID: 7***04 Birmingham, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Thesis: 1.8 Pages, Deadline: 6 days

Very good job I am very happy when I get marks I very very happy thank u so much for helping me

flag User ID: 5***67 Canada

student rating student rating student rating student rating student rating
02 Dec 2021

Mechanical Engineering

Programming: 6 Pages, Deadline: 15 days

was in time good experience, hope would have scored good grades. Good maintained and very much friendly service.

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

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Essay: 6 Pages, Deadline: 5 days

excellent work thank you i will always use this website and tell and advise my friends and colleagues about you guys but there must be more discounts ...

flag User ID: 7***75 Kuwait

student rating student rating student rating student rating student rating
02 Dec 2021

HRM

Programming: 2 Pages, Deadline: 4 days

all work done well with good referencing and proper words i got a very good score for this particular course and i am happy about that. thank you so ...

flag User ID: 8***18 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

HRM

Assignment: 3.6 Pages, Deadline: 3 days

submitted my work and the lecture acknowledge my work saying that it was good and i did a very good work.

flag User ID: 8***18 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Assignment: 16 Pages, Deadline: 16 days

Very supporting and helpful, I am happy to express that the assignment and writing is very good and helped me to achieve good achievement in study.

flag User ID: 4***58 Malaysia

student rating student rating student rating student rating student rating
02 Dec 2021

English

Essay: 4 Pages, Deadline: 9 days

Very good paper, included everything and helpful. I got a grade on the essay, received a 100 on my paper. I highly recommend this website!

flag User ID: 6***89 United States

student rating student rating student rating student rating student rating
02 Dec 2021

Marketing

Assignment: 10 Pages, Deadline: 11 days

Excellent job. Very timely. Customer service was top-notch. Even my lecturer was impressed.

flag User ID: 8***83 Canada

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Assignment: 7 Pages, Deadline: 9 days

I am very happy when I get marks I feel very verry good I got good marks thank u so much for helping me

flag User ID: 5***67 Canada

student rating student rating student rating student rating student rating
02 Dec 2021

Project Management

Essay: 9 Pages, Deadline: 1 day

was a part of my programme management curs level 5 i passed it with 85% and that is soo good for me, thank you

flag User ID: 7***04 Birmingham, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Thesis: 1.8 Pages, Deadline: 6 days

Very good job I am very happy when I get marks I very very happy thank u so much for helping me

flag User ID: 5***67 Canada

student rating student rating student rating student rating student rating
02 Dec 2021

Mechanical Engineering

Programming: 6 Pages, Deadline: 15 days

was in time good experience, hope would have scored good grades. Good maintained and very much friendly service.

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

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Essay: 6 Pages, Deadline: 5 days

excellent work thank you i will always use this website and tell and advise my friends and colleagues about you guys but there must be more discounts ...

flag User ID: 7***75 Kuwait

student rating student rating student rating student rating student rating
02 Dec 2021

HRM

Programming: 2 Pages, Deadline: 4 days

all work done well with good referencing and proper words i got a very good score for this particular course and i am happy about that. thank you so ...

flag User ID: 8***18 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

HRM

Assignment: 3.6 Pages, Deadline: 3 days

submitted my work and the lecture acknowledge my work saying that it was good and i did a very good work.

flag User ID: 8***18 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Assignment: 16 Pages, Deadline: 16 days

Very supporting and helpful, I am happy to express that the assignment and writing is very good and helped me to achieve good achievement in study.

flag User ID: 4***58 Malaysia

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?