The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Apr 2017 |
| Last Sign in: | 103 Weeks Ago, 4 Days Ago |
| Questions Answered: | 4870 |
| Tutorials Posted: | 4863 |
MBA IT, Mater in Science and Technology
Devry
Jul-1996 - Jul-2000
Professor
Devry University
Mar-2010 - Oct-2016
Can you do this assignment for me.Instructions,Rubric and instrctor's comment for week 2 assignment attached as request per assignment.
Â
Database Schema-SQL statementsAssignment instructionsDetails:1) Based on the feedback received on your Topic 2 assignment Database Schema, provideSQL statements to create the (revised) database and populate it with sample data (at leastfour rows per table).2) Modify the database by adding an additional column ("Deleted_Date") to those tablesthat represent entities that could contain data which can be deleted and justify yourrationale in a short paragraph. In addition, explain what the tradeoFs are in using amarker-column for deletion, as opposed to actually deleting a row from a table?3) APA format is not required, but solid academic writing is expected.4) This assignment uses a grading rubric. Instructors will be using the rubric to grade theassignment; therefore, students should review the rubric prior to beginning the assignmentto become familiar with the assignment criteria and expectations for successful completionof the assignment.Rubric AttachmentDatabase Schema-SQL Statements1Unsatisfactory0.00%2Less ThanSatisfactory74.00%3Satisfactory79.00%4Good87.00%5Excellent100.00%100.0 %Module 4Rubric: DatabaseSchema—SQLStatements20.0 %SQLStatementsSubjectknowledge isnot evident.Little subjectknowledge isevident.Some subjectknowledge isevident.Demonstratecomprehensionof subjectknowledge inthe SQLStatements.Demonstrateexceptionalsubjectknowledge inthe SQLStatements.20.0 %DatabaseDatabasemodificationsare either notpresent or notevident.Databasemodificationsare missing orincorrect.Little subjectknowledge isevident.Databasemodificationsare mostlycompleted.Some subjectknowledge isevident.Databasemodificationsare clearlycompleted.Databasemodificationsarecompetentlycompleted.30.0 %RationaleIncludes littleknowledgeIncludes littleknowledgeIncludesknowledgeIncludesessentialCovers topicin-depth with
Attachments:
-----------