Get 20% Off + $20 Signup Bonus ! Limited Time, Hurry !
Get 20% Off + $20 Signup Bonus ! Limited Time, Hurry !
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.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

39 Pages
Corporate Governance & Ethics

For this assessment item, you are to research and report on the exploitation of foreign labour and the suppression of their human rights in one country of your choice. The country to choose ...

Type

Assignment

Subject

4 Pages
Intellectual Breach: Security Strategies of Australian Software Companies With Markets in the Austr

Assessment type: Thesis Porposal (13,000 words) Assessment Topic: “ Intellectual Breach : Security Strategies of Australian Software Companies With Markets in the Australasia” Word Lengths ...

Type

Thesis

Subject

3 Pages
global business assignment

Write a report based on Porters Factor conditions from the diamond model on Australia’s Wine Industry. 1. Brief background of the firm and how it relates to international business 2. H ...

Type

Thesis

Subject

4 Pages
HLT51612 Diploma of Nursing

If midpoint of the continuum/pathway represents the neutral point, where would you place Joan who recently had a Transient ischemic attack and is currently stating weakness in her right arm?Reflecting ...

Type

Home Work

Subject

PC 206 Database Management Systems

Question

Answered

This Assignment is based on the following scenario. Its approach is incremental, with tasks to be completed during the teaching weeks 4 to 9. It is designed to go through a relational database design, build (code), test and document the development cycle. Your task as a group is to: 1. Develop a working database using SQL based on the following scenario 2. Present a 10-minute presentation of your proposed solution and strategy as if to the client 3. Document your group’s work in a written report 4. Give advice and recommendations on how to keep this database safe from accidental and deliberate threats which may lead to significant data loss in your written report. – This is worth 50% of your total mark for the module. Scenario: A small counselling & psychotherapy business require an information system to store client details, record data and assist counsellors in decision making by producing routine reports on the outcome of the sessions. The organisation consists of one Managing Director (MD), one Personal Assistant (PA), 4 Qualified Counsellors and 6 Support Staff; they currently record counselling sessions on paper without a database system (see session log: page 6). Your task is to suggest and design a suitable database system for this business. The proposed system should: • Store client and session details in MySQL or WebSQL • Incorporate meaningful data search capabilities to identify bookings, room availability, billing and any other relevant information will help management team with the running of this business. For this project you are required to develop a suitable database model. Your database must be in the 3rd normal form at a minimum and must not allow data duplications/redundancies. In addition, you must populate your database with data suitable to run complex queries on involving more than one table. Moreover, you must create two appropriate user views and triggers help automate regular tasks and manage user views. Total marks for assignment: 100 Specific Marking Criteria and Guidance: You should work in groups of 2 to develop your database, presentation and report. The emphasis of your database model should have been on creating a database model in the 3rd normal form with built in constraints to enable the system to maintain the accuracy and consistency. You should show a good understanding of the concept of data loss and/or inconsistency due accidental, unintentional and/or deliberate user acts. Specific Marking Criteria and Guidance: Database In order to pass, your database should be designed using correct data types, primary and foreign key fields. ER model must not allow data redundancy/multiplicities. Database populated with relevant data and simple search capabilities documented in the project report. In order to achieve a 2.2 mark, your database should be designed using correct data types, primary and foreign key fields. ER model must not allow data redundancy/multiplicities. Database populated with relevant data and complex search capabilities documented in the project report. Security features of the model must be discussed referencing relevant update sources. In order to achieve a 2.1 mark, your database should be designed using correct data types, primary and foreign key fields. ER model must not allow data redundancy/multiplicities. Database populated with relevant data and complex search capabilities documented in the project report. There must be evidence of the use of natural join and successful execution complex queries including use of aggregates functions. Triggers must add value to the database functionality such as limiting the incorrect bookings. Minimum of two user views must be present. The collection of these database objects must add value to the daily functions of the business. The development cycle must be clearly recorded in the project report and security features discussed in depth with up-to-date referencing. In order to achieve a First Class your database should be designed using correct data types, primary and foreign key fields. ER model must not allow data redundancy/multiplicities. Database populated with relevant data and complex search capabilities documented in the project report. There must be evidence of the use of natural join and successful execution complex queries including use of aggregates functions. Triggers must add value to the database functionality such as limiting the incorrect bookings. Minimum of two user views must be present. The collection of these database objects must work seamlessly together adding value to the daily functions of the business. The developer must make the security and usability the priority of their design. The development cycle must be clearly recorded in the project report. Furthermore, a highly functional working model of a database must have been developed, which is suitable to implement for a real business. Specific Marking Criteria and Guidance: Presentation Your presentation should take about 10 minutes with another 5 minutes for questions about the suitability of your design and security features of your final design proposal. Your presentation should be aimed at the client. You should present as if you were database developers pitching your solution to the client’s IT director and Chief Executive. You should book a time slot for your presentation using the online booking form at: http://goo.gl/forms/C1OlQ4Livg. Make sure you enter your student details correctly to the booking form. You will NOT be given any technical assistance during your presentation so you should practice on a lecturer’s computer prior to their presentation by running it from a flash memory stick. In order to pass, your presentation should clearly demonstrate a usable database and database strategy appropriate to the client. Your presentation should present the strategy in clear and logical way demonstrating appropriate to the needs of the client. In order to achieve a 2.2 mark, your presentation should demonstrate an awareness of how the proposed solution relates to the client’s business. In order to achieve a 2.1 mark, your presentation should show how the particular development decisions you have made relate to the client’s business needs and wider strategy. A First Class presentation would demonstrate a critical awareness of the role of databases in contemporary business and the challenges and opportunities they present (e.g. in terms of security, privacy etc...) backed up with comprehensive academic research. The proposed project solution must be a highly functional working model of a database which is suitable to implement for a real business without compromising the business goals and objectives. Specific Marking Criteria and Guidance: Report Each student should submit an identical copy of the report through turnitin via student portal. (All group members Name, Surnames and Ids must be clearly printed on the cover page) Your report is designed to document: the development work, if screen-shots/code present it must be annotated. The Project Report should have the following structure and content: Cover Page: Assignment title, module code, full name and student number (all members), as well as submission date. Table of Contents: A list of all of the sections, headings and sub-headings, appendices and figures should be provided as well as all page numbers as clearly as possible. Introduction: This should summarise your response to the task and the strategy you are presenting. Development Log This is the substance of your report. You should take your reader through the decisions you made and the work you did in developing your database. You should use the client’s brief (in the question) to structure your log, clearly demonstration how you addressed each of the client’s task and demands. Headings and sub-headings should be used to clearly indicate the different sections addressing all the sections of the marking criteria. You should clearly note how each member of the group contributed. It is not necessary for every group member to contribute to every part of development. If one member concentrated on one aspect, that should be noted and explained why that was the best use of your group’s resources. You are required to include your tables including designs, ER diagrams, data entry, queries, query results, triggers, user views and safety features in the body of your report. Screen-shots must be annotated. You must show evidence of testing at every stage of your development cycle. Conclusions: These draw out the implications of your findings. Deductions are based on the facts described in the findings and analysis. Remember not to include any new material here. References: All the named sources you have quoted from or reproduced in your report. Please use The Harvard System for all references. Details for the Harvard System can be found on the student portal. Appendices: Detailed documentation of points made in the findings. Examples include: technical data, questionnaires, letters sent, tables, charts or leaflets. An appendix contains supplementary information that you consider to be too long, complicated or not quite relevant to include in the main section of the report, but is still relevant to your reader. Each appendix should be referred to in your text. You should not include something as an appendix if it is not discussed in the report. In order to pass, your report should present your development work and strategy in clear and logical way demonstrating how you addressed the needs of the client. In order to achieve a 2.2 mark, your report should demonstrate how you addressed the specific needs of the client’s business In order to achieve a 2.1 mark, your report should show how your group’s development decisions you have made in relation to the client’s business needs and wider strategy. A First Class report would demonstrate a critical awareness of how your group sought to develop a database in the light of discussions around the role of databases in contemporary business and the challenges and opportunities they present e.g. in terms of security, privacy etc.. Use of time and division of tasks must be realistic and demonstrated clearly in the report. Assessment Components % Identifying Entities, Attributes, Relations and Identifiers 10% Entity Tables Normalisation (Must be at the 3rd normal form at a minimum) 10% E-R Diagram in UML notation 10 % Creating required number of tables with the required relations between entities and populating them by using SQL. 10% Constructing complex queries involving minimum of two tables using SQL language (you must be able to demonstrate an ability to use natural join and execute complex queries including aggregates) 10% Two appropriate user views and triggers 10% Introduction 5% Conclusions 5% Security features and advice 7.5% Concurrent database access anomalies 7.5% Structured report, Harvard style referencing 5 % Professionally presented with full group participation 10 % Total 100 %

PC 206 Database Management Systems

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.

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

MyAssignmenthelp.com produces the most exceptional and professionally written thesis papers for students of all levels. We have a team of professional thesis writers who are capable of providing highest quality thesis writing services to students in USA. While availing thesis help from us, students don't need to think about is it safe to pay someone to do my thesis . The reason being we are the most reliable thesis help providing company that students can trust in USA. So students can stop wondering, can someone help me with my thesis paper, and avail our services.

More PC 206 Database Management Systems: Questions & Answers

Q

Corporate Governance & Ethics

For this assessment item, you are to research and report on the exploitation of foreign labour and the suppression of their human rights in one country of your choice. The country to choose from is: ·         Australia ·  &n ...

View Answer
Q

Intellectual Breach: Security Strategies of Australian Software Companies With Markets in the Austr

Assessment type: Thesis Porposal (13,000 words) Assessment Topic: “ Intellectual Breach : Security Strategies of Australian Software Companies With Markets in the Australasia” Word Lengths: 13,000 Words Due date: Friday 14th November 2014 Reference Style: HARVARD Academic References: 60 ...

View Answer
Q

global business assignment

Write a report based on Porters Factor conditions from the diamond model on Australia’s Wine Industry. 1. Brief background of the firm and how it relates to international business 2. How does the case study relate to a specific lecture topic? Relate it to at least 2 lecture ...

View Answer
Q

HLT51612 Diploma of Nursing

If midpoint of the continuum/pathway represents the neutral point, where would you place Joan who recently had a Transient ischemic attack and is currently stating weakness in her right arm?Reflecting on Joan’s situation what health care issue requires nursing care?Analyse on what you have lea ...

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

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?