$1$ Assessment $2$

$1\mathrm{.}1$ Section A $=$ Database $[20]$

$1\mathrm{.}1\mathrm{.}1$ Create the database for your system $(20)$

$[$Now you must create the database, keep in mind the structure of the tables, columns, PK$$s and FK$$s$,$ etc. $...$

Now you must import the data into your database and describe the process$($es$)$ that you followed, problems that you've experienced, etc. Be very specific; the more information you provide, the better.

For example:

o If you have created programming scripts and procedures to complete this task, describe it to the marker OR

o If you have followed prompts and buttons in the database of your choice, describe it to the marker.

Furthermore, describe the problems you have experienced during the import process, and more important describe how you have solved it$.]$

$[$Add your answer here $...$

You will also have to provide screen captures as evidence of the data successfully imported in the database. The screen captures should clearly show the tables, columns, screen shots of data imported, etc. The more information you provide, the better.$]$

$1\mathrm{.}2$ Section B $=$ Backup and Recovery for the Database and Programming code $[10]$

$[$Remember software must be free and not have a trail period, that can expire before your examination of your system at the end of the year.$]$

$[$You will not be able to use as an excuse at the end of the year that your system has crashed or that you have changed something at the last minute and now the system is not working anymore.

Thus...

Having a data backup and recovery plan is important to the overall success of your system.

Without one, YOU and then the School may suffer from permanent data loss, massive downtime, and unnecessary time wasted and expenses.

It is important that you have a backup and recovery process in place. Just indicating that you backup to a $"$CD$"$ or the "Cloud" or even a "Memory stick" is not sufficient at all.

The purpose of the backup is to create a copy of data that can be recovered in the event of a primary data failure.

Primary data failures can be the result of hardware or software failure, data corruption, or a human$-$caused event, such as a malicious attack $($virus or malware$),$ or accidental deletion of data.

In this section you have the opportunity to describe the backup and recovery processes that you have put into place. The processes and methods for both backup and recovery $($restoring$)$ of the data will depend on the database that you have chosen. Thus, you will describe it in terms of the database environment of your choice. Again, be specific, add screenshots as evidence. Convince the marker that you have backup and recovery in place and that you know how to implement and use it$.($Do not copy and paste "theory" from the Internet or some or other textbook $-$ you need to describe how you have implemented backup and also how you will recover data$).]$

$1\mathrm{.}2\mathrm{.}1$ Database $(5)$

$[$Add your answer here for the backup and recovery plan for your database $...]$

$1\mathrm{.}2\mathrm{.}2$ Programming code & Portfolio $($assessments $-$assignments$)(5)$

$[$Add your answer here for the backup and recovery plan for your programming code and your Portfolio $($assessments $-$ assignments$)...]$