SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 1 Day Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 28 Nov 2017 My Price 10.00

Using SQL Server 2016. Building upon your project

Using SQL Server 2016. Building upon your project 1, the park will be a Star Wars themed park. You must design additional parts of the database and create the following SQL Script. 

Building upon your project 1, the park will be a Star Wars themed park. You must design additional parts of the databaseand create the following SQL Script.Step 1: Design and create the tablesYou must create additional tables to hold Project and Activity Data.Aprojectrepresents the construction of a facility with a limited scope of work and financial funding. A Project can becomposed of many activities which indicate the different phases in the construction cycle.Example Project Name:Bobba Fett’s Bounty Chase RideAnactivityrepresents the work that must be done to complete the project.Example Activity Name:For Exampleactivity name could be “Phase 1 Design of Bounty Chaseride”Or name could be “Final construction of Bounty Chase ride”Etc…You must normalize the project table to come up with a new set of tables. You will then write the create script for thesetables.Project(projectId, projectName, firmFedID, firmName, firmAddress, fundedbudget, projectStartDate,projectStatus , projectTypeCode, projectTypeDesc, projectedEndDate, projectManager, (activityId, activityName,costToDate, activityStatus, startDate,endDate) )To normalize the tables, you must use the following function dependencies:ProjectId,ActivityId -> projectName, firmFedID, firmName, firmAddress, fundedbudget, startDate, projectStatus ,projectTypeCode, projectTypeDesc, projectedEndDate, projectManager, activityName, costToDate, activityStatus,startDate, endDate.projectId -> projectName, firmFedID,fundedbudget, startDate, projectStatus , projectTypeCode, projectedEndDate,projectManager.projectTypeCode -> projectTypeDescfirmFedID -> firmName, firmAddressProjectId, ActivityId -> activityName, costToDate, activityStatus, startDate, endDateWhen creating the tables,use the following column names and data types (important)for columns:oprojectId(char(4)) : A 4 character unique identifier (numbers and letters).oprojectName(varchar(50)) : The name of the construction project.ofirmFedID(char(9)) : A 9 character Federal ID (Example: 123456789)ofirmName(varchar(50)): The name of the construction firm.ofirmAddress(varchar(50)) : The address of the construction firm.
Background image of page 1
ofundedbudget(decimal(16,2)): The money amount allocated to this projectoprojectStartDate(date): The date the project started.oprojectstatus(varchar(25)): The status of the project (either active,inactive,cancelled,completed)oprojectTypeCode(char(5)): The project type code areFAC, RIDE, RET, and FOOD.oprojectTypeDesc(varchar(50)): The project type descriptions for a project are: Facility, Ride, Retail andRestaurantoprojectedEndDate(date) The date the project is scheduled to end.oprojectManager(char(8)) The employee number of the employee who is managing this projectoactivityId(char(4)): A 4 character unique identifier for the activity.oactivityName(varchar(50)): The name of the activity.ocostToDate(decimal(16,2)): The cost of the activity to date.oactivityStatus(varchar(25)) : The status of the activity (either active,inactive,cancelled,completed)ostartDate(date): The date the activity began.oendDate(date): The date the activity ended.You will write the script to create the tables which resulted from your normalization. Each table should have a primary key defined.You should have more than one table after you normalize.Step 2: Create Stored Procedures to populate the tablesYou will create the SQL Scripts to create procedures to insert/ update data. The following definitions specify theparameters that can be passed in. The underlined parameters are required.Make sure that your procedure inserts records if the required parameters do not exist, but they update records if therequired parameters do exist.For example:If SP_AddUpdateProject: passes in projectID “AA01” and it DOESN’T exists in the project table(s) , it will insert the valuespassed in.If SP_AddUpdateProject: passes inprojectID “AA01” and it DOES exists in the project table(s) , it will UPDATE the valuespassed in for the AA01 record.Procedures Needed:-SP_AddUpdateProject:Adds/Updates a project with all the field information.oParameters:projectId, projectName, firmFedID, fundedbudget, projectStartDate, projectStatus,projectTypeCode, projectedEndDate and projectManager-SP_DeleteProject:Deletes a project by the project Id.oParameters:projectId-SP_AddUpdateActity:Adds/Updates activity with all the field information.oParameters:activityId, activityName, projectId, costToDate, activityStatus, startDate, endDate-SP_DeleteActivity:Deletes an activity by the activity Id.oParameters:projectId, activityIdStep 3: Create Stored Procedure to Process Project DelaysYou will create the SQL Script to create procedures to insert/ update data and process a project delay

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 28 Nov 2017 02:11 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)