update part 2

profileseafood1
GroupProjectChecklistPart1andPart2.docx
Home>Computer Science homework help>update part 2

The Group Lab Project will be delivered in two parts. The requirements for each part are as follows:

 Part 1 - Lab Project Checklist:

1. Cover Page, title and team member names

2. Project plan, preferably in MicroSoft Project tool

3. ERD - normalized

4. ERD denormalized, if team denormalized model

5. DDL for tablespaces

6. DDL for objects

7. Calculations for sizing objects or source of sizing (hand or ERWin)

8. Results of query on catalog showing all objects with valid status

9. DB Installation outputs.

10. Installation checkout commands and sample output

11. Create DBA user script

12. Alter users script

13. Export command and output

14. Sql Loader Control files for 10 table loads

15. Analyze commands for each table

16. Query output showing row numbers from catalog

 

Part 2 - Lab Project Checklist:

 Please do not include part 1.

1.  SQL commands to ALTER a table, add a column, lengthen a column, shorten a column, change a data type for a column from NUMBER to CHAR and then CHAR to NUMBER.

2.  Commands to create another table like an existing one but without one column. Then load the data from the old to the new table. Then reestablish referential integrity. Then drop the old table and rename the new one.

 3.  Design for a test of restructuring existing objects for points 1 &2 above.

 4.  Scripts to capture static performance statistics.

5.  Design and Scripts for Performance testing.

6.  Scripts to capture dynamic performance statistics.

7.  A matrix with the results of the performance testing that was done as a DBA.

8.  A script to create a small table with 3 rows for recovery testing.

9.  Backup and recovery commands for Recovery testing using export/import and RMAN utilities.

10.  Design and backup/recovery commands for your test.

11.  Include explanations for what happened during the recovery when import vs. RMAN was used.

12.  Flashback recovery commands.

13.  Scripts that could be used to monitor the health of the database (status, space, invalid objects, and other statistics).

14.  Sample output from statistics queries.

15.  Sample output from invalid objects queries.

16.  Scripts used to create end-users. Including create, access, grant privileges.

17.  Scripts used to create synonyms.

18.  Scripts used to query all_objects views for reverse engineering exercise. Output from reverse engineering queries.

19.  DBA scripts to detect end-users and what they are running on your database.