Thrillwill

Sep 29th, 2013

Anonymous

Category:

Other

Price: $30 USD

Question description

ProfessionalLitigation User Services (PLUS) is a company that creates all types of visualaids for judicial proceedings. Clients are usually private law firms, althoughthe District Attorney’s office has occasionally contracted for its services.

PLUS creates graphs,maps, timetables, and charts, both for computerized presentations and in largesizes for presentations to juries. And anything else of a visual nature thatcan be used in a judicial proceeding to make, clarify, or support a point.

Raj Jawahir isresponsible for tracking the daily payments received from PLUS clients. You’llhelp him maintain the PLUS database by creating the following ERD and tables:

1.Use SQL Server tocreate a new database with 2 tables based on the ERD/TICs above.

1.Complete all of thesteps outlined above in the Assignment Description.

2.When you are finished,take the following screenshots and paste them into ONE Word document:

oOne screenshot in the Object Browser of theDatabase name PLUS and both table names.

oOne screenshot of each table (Firm andPayment) expanded in the Object Browser. All column names, constraints(Primary, Foreign, Not Null), data types and length must be visible. For thePayment table make sure the Foreign Key constraint is visible in thescreenshot.

oOne screenshot of each table (Firm and Payment)in the “Edit Top 200 Rows” view. Must be able to see data in all columns – youmight have to take more than one screen shot for the Firm table if you areunable to view all columns.

oAfter you have inserted data into both tables,write the following Select statements to test the database. Take one screenshot of each Select statement and the results.

3.Write one selectstatement that will retrieve all the rows from the Firm table.

4.Write one selectstatement that will retrieve the paymentid, firmid and amount paid from thePayment table. Sort the results by amount paid in ascending order.