Ideas

Survey Questions 

  1. Can you tell me how many tables you want?

2. Regarding the singer table, can you tell me what details of the band you need?

3. Will you need 1 or more contact personnel for this band?

4. Will you need an email, phone number, etc in order to contact the band?

5 Have I missed anything in terms of minutia detail for the table?

6. Regarding the event table, what details are you after, should I be general and write about it briefly, or should I detail each important section?

7. In addition to location, will you need date and time?

8. Will you need cost of venue or other expenses such as catering and special effects/pyrotechnics?

For more information and my proper survey, here is the link: https://www.surveymonkey.com/s/38FSP9D 

3 Communication Techniques 

Required Database Inputs

Definition of Primary and Foreign Keys

A Primary Key is a column or group of columns that uniquely identify a row. For example, Events_ID, Genre_ID and Singer_ID.  Every table should have a primary key. And a table cannot have more than one primary key. The Primary Key characteristic can be specified as part of a column definition. While a value can appear more than once in any of these columns taken individually, the fact that they are collectively a primary key means that the three values taken together cannot occur in more than one row.

 A Foreign Key is a column or set of columns in one table whose values must have matching values in the primary key of another, or the same table. A foreign key is said to reference its primary key. Foreign keys are a mechanism for maintaining data integrity. 

Customer Table/Data-Dictionary

Compare and Contrast Validation and Verification

Validation
Validation is one way of trying to reduce the number of errors in the data being entered into your system.

The validation is performed by the computer at the point when you enter data.  It is the process of checking the data against the set of validation rules which you set up when developing your new database or spreadsheet system.

Validation aims to make sure that data is sensible, reasonable. However, it does not check that the data is correct.

While validation can help to reduce the number of errors when entering data, it cannot stop them, which is why human error plays a major role in faulting most databases, and should therefore be minimised as much as possible.

In my database I could use validation to check that all fields are filled in, and make sure that any minor details such as type of database are correct, which would be very precise. 

Verification
Verification means to check that the data on the original source document is identical to the data that you have entered into the system or object document.

It was mentioned earlier that validation cannot make sure data that you enter is correct, it can only check that it is sensible, reasonable and allowable.

However, it is still important that the data in your database is as accurate as possible.

Verification can be used to help make sure that the data in your database contains as few mistakes as possible.

In my database, I could use the double method of verification to make sure all the band information is correct​

Appropriate Reports I will require

Reports are a good way of presenting data in a fixed, and easy to manage way. A report is a document (paper or electronic) that presents data in an easy-to-read, professional format. Database reports are presented in an attractive format, with headings, fonts and colours designed to enhance understanding of the data.

Some examples of appropriate reports that I will use in my database are:


Reports on the number of upcoming events 


This is so that we can keep track of the upcoming events that our company is responsible, and therefore we will not miss any events. This will be helpful to also come up with plans for catering and venue hire.These have to be presented formally and attractively as customers may want to access the list of upcoming events.

Reports on event profits 

This is so that we can see the income revenue the company is generating, and also keeps track of whether we are losing or gaining money. This will ultimately lead to creating more economically wise decisions in terms of spendings, and the need for care when considering consumer choice. This needs to presented formally and professionally as to not lose any data. Losing data might mean that a significant profit gained from an event could be lost.

Reports on popularity of bands

 This is so that we can see the current trends floating in the music industry, and thus Tap Out Inc. can hire these bands to generate significant revenue, and helping both the creator of the database and Tap Out to increase funds, benefiting both parties. Customers might also want to access these trends, as well as corporate officials. To do this we must also present it in a formal manner. Furthermore, we can also see which bands are currently unpopular, and thus Tap Out choose particular bands and stay away from less popular ones to discourage loss.​

Appropriate Queriers I will require

A query is a request for information from a database which matches a set of criteria. The DMS engine looks through its database and displays a list of results which match the term that you used.

Some examples of appropriate queries that I will use in my database are:

When is a (singer/band) performing?

This is so that the audience and fans can get informed when a specific band is performing. This would advertise the performance, and give all details of the date, time and ticket price so that the maximum amount of people show up. This lets Tap Out Inc generate the maximum profit without breaching personal information, whilst effectively planning between each performance. 

What is the location of the event? 

This is so that customers and the audience can know when and where the event it. Through putting this information out there, we can guarantee that a large amount of people will turn up if it is a popular band, and will allow the road-crew and technicians to set up stage and plan the audio and pyrotechnics for the performances. Customers would want this information, and by having this query we are making their information more accessible.

How many tickets are available? 

This is so that customers can know how many available tickets there are left. Through this, they won't have to just assume there are no tickets left for sale. Customers would want to query this so that they can see if they can still purchase tickets, either individually or in bulk sales (for 3rd party retailers). This would also promote sale of tickets as more customers would buy tickets if they know there is a large amount available.

Examples of data security methods