PT2520

Powerful Essays
Lab 10 Course Project
Purpose
In this final lab, you will apply the knowledge acquired from Units 4-9 of this course to completing a project, which will require the following skills:
Creating tables
Creating a composite key
Adding columns to an existing table
Creating a stored procedure to guard against a SQL injection attack
Granting permissions
Applying the concept of clustered indexes
Creating a non-clustered index
Creating a trigger
Executing queries to meet requirements

Project Scenario
The course project is based on the Westlake Research Hospital scenario that you have been studying throughout the course and uses the Westlake database you used for the Group A labs. To complete the project, you will need to use your copy of the SQL2008ExpVM virtual machine, as it existed at the end of the last unit (Unit 9). Your instructor will provide you with a script file named ProjectLoadData.sql, which you will use to populate the database. You will receive instructions on how to use this file in Step 10 of the Technical Steps section of this lab.

Expected Deliverables/Outcomes
Upon completion of the project, you will submit a MS Word document with the answers to the three questions integrated within the project at key points. Questions 1 & 2 are located at the end of Step 11 and Question 3 at the end of Step 12 of the Technical Steps section of this lab. This MS Word document will be named nn_Projectanswers.doc where “nn” will be changed to your initials.

You will also submit eight screen shots of specific steps of the database for the project. These eight screen shots should each be a separate file. The filename of the screen shot will take the format of nnProject_XX_X, where nn is your initial and XX_X corresponds to the Step number in the section of Technical Steps of this lab. The following are the required screen shots for submission (Substitute your initials for nn): nnProject_6 nnProject_11_2 nnProject_13 nnProject_14_1 nnProject_14_2 nnProject_14_3

You May Also Find These Documents Helpful

  • Satisfactory Essays

    CS320 Lab1

    • 874 Words
    • 3 Pages

    format and submit it to the course canvas. This covers SQL Part A (Chapters 2,8&…

    • 874 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Discussion Board

    • 460 Words
    • 2 Pages

    I need to complete this assignment but I am having a hard time understanding it. Can someone give me some pointers on what to write on the DB? I just need a guide to start off with.…

    • 460 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    Database plan purpose: This step will include the discussion of the purpose of the database that will be used at Riordan.…

    • 3100 Words
    • 13 Pages
    Better Essays
  • Good Essays

    CMGT 400 Week 1 DQs

    • 676 Words
    • 3 Pages

    The project for CIS336 is designed to touch all aspects of the fundamental concepts of database design and logical data modeling covered during the class. The project is team centered and each team will be responsible for designing, developing, and demonstrating the functionality of a database created based on a defined set of business specifications. At the end of the session, each project team will submit the database designed by the team and demonstrate the database's ability to deliver the required information as outlined in the project specifications. All aspects of the project will be ...…

    • 676 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Syllabus 2

    • 1288 Words
    • 6 Pages

    This course covers the concepts of databases and data base usage, database system concepts and architecture, data modeling using the entity-relationship model, record storage and primary file organizations, index structures for files, relational model concepts, SQL-the relational database standard, relational database design , examples of relational database management systems: Oracle, database design, database recovery techniques, database security and authorization, data warehousing and data mining.…

    • 1288 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    Testing

    • 349 Words
    • 2 Pages

    Lab 1 of 7: Introduction to MS Visio and MS Access Scenario/Summary: You have been asked to create two conceptual database models using MS Visio Database Model Diagram Template. The purpose of this lab is to have you gain familiarity with the various modeling tools needed to create a conce…

    • 349 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Grocery Store Database

    • 2626 Words
    • 11 Pages

    The Database Team has agreed to have a fully functional system in place by December 1, 2002. A preliminary budget of $75,000.00 has been approved and allocated to this project.…

    • 2626 Words
    • 11 Pages
    Powerful Essays
  • Satisfactory Essays

    In addition to in-class quizzes and homework assignments, each student will undertake a project. They will be required to present the results of their analyses in the class and submit it in the form of a term paper. Further instructions about the course project will be given in the class. Grading plan will be as follows:…

    • 254 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Database Technology

    • 576 Words
    • 3 Pages

    DATABASE TECHNOLOGIES CLASS T.E. ( INFORMATION TECHNOLOGY) HOURS PER LECTURES : 04 WEEK TUTORIALS : -PRACTICALS : 02 HOURS EVALUATION THEORY 3 SYSTEM: PRACTICAL -ORAL -TERM WORK --…

    • 576 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Question Bank

    • 556 Words
    • 3 Pages

    UNIT - 1 1. Explain advantages of database over file system 2. Describe Three Level Architecture. 3. Explain Data Independence with its Types and Examples. 4. Definition : 1) Assertion 2) Authorization 5. Explain Object-Oriented Data Model 6. Explain Semi-Structured Data Model. 7. Explain Database System Architecture. 8. Explain Duties of Database Administrator. UNIT - 2 9. What are the steps involved in designing a database application? Explain with an example. 10. What is E-R Model? What is purpose of E-R Model? 11. Explain Entity and Entity Sets with Examples. 12. Explain Relation and Relationship Sets with Examples. 13. What is Attributes? Explain types of Attributes with Example 14. What Cardinalities in Database System? Explain types of cardinalities. 15. Explain Superkey, Candidate Key and Primary key with proper example. 16. Explain Participation Constraint with Example. 17. Explain Weak Entity Set. 18. Explain E-R diagram components. 19. Explain Subtype and Supertype with Example. 20. Explain Generalization and Specialization with Example. 21. Explain Aggregation Relationship with Example.  NOTE: IN UNIT – 2 NOT INCLUDE E-R DIAGRAM QUESTION.…

    • 556 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    This study guide prepares you for the Final Examination you complete in the last week of the course. It contains practice questions, which are related to each week’s objectives. Highlight the correct response, and then refer to the answer key at the end of this Study Guide to check your answers.…

    • 1701 Words
    • 7 Pages
    Good Essays
  • Powerful Essays

    4. For further help see the Sample Final Lab Report for an example of a final product on a different topic.…

    • 2582 Words
    • 10 Pages
    Powerful Essays
  • Satisfactory Essays

    This lab requires you to focus on variable assignment and calculations. Read the following program prior to completing the lab.…

    • 777 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    Pa250 Unit 1

    • 783 Words
    • 4 Pages

    One of the basic rights we hold sacred in this country is the freedom to marry whomever we choose. While that seems like a given in the US, because we don’t have the strict class hierarchy of Europe, or the arranged unions found in certain Eastern and African cultures that define who marries whom. We have had, and still do for that matter, rigid restrictions on marriage, when they seem counter-intuitive to social mores. When social feelings begin to shift towards a more progressive outlook, challenges to the status quo are bound to occur, especially when the emotionally charged aspect of marriage is involved. Two perfect examples are the cases of Loving v. Virginia 388 US 1, 87 S Ct1817(1967), and Goodridge v. Department of Public Health 440 Mass 309, 798 NE 2d 941(Mass.2003).…

    • 783 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Dbm380 Course Syllabus

    • 2296 Words
    • 10 Pages

    Database Management Systems Paper (Week 1) Database Environment Paper (Week 2) ERD Creation Project (Week 3) Normalization of the ERD (Week 4) No Individual Assignment Due (Week 5) Participation (2 points…

    • 2296 Words
    • 10 Pages
    Satisfactory Essays