Problem

My final design brief

TAPOUT Music Inc. has asked me to create a proficient database which will manage the details of the singers that they are in charge of. They have elected me as database Administrator, in which my role is to develop an easily accessible database, which will allow access to all records of singers in as proficient a way as possible. 







Criteria for success
  1. Must be an easily accessible database
  2. Must include at least 3 tables or more. 
  3. Must be heavily detailed and provide clear information
  4. Must fulfil TAPOUT Music Inc.'s requirements 
  5. Must be easily navigable 
  6. Must be appropriate for school aged students aswell as adults (young adults 15+ ) 
Limitations 
  1. There are only a select few software applications that will allow me to create a proficient and easily accessible database (e.g. Microsoft Access) 
  2. The time could be an issue, as there is only a few weeks before the Music company will demand my database. 
  3. Originality is key when creating a database, so it is imperative that your database not only functions at its peak, but provides a creative flare, ultimately giving it the edge over other databases. 

Areas of Investigation





Table outlining the impacts of the Solution 


Technical
Hardware I will require includes

1)   Computer (CPU, RAM, Motherboard, PSU etc.)
2)   Peripherals, (keyboard, mouse, monitor)
3)   Printer
4)   Backup storage HDD
5)   Bar-code scanner

Technical
Software I will require

1)   Operating system
2)   DBMS- (Microsoft Access)
3)   Word Processor (Microsoft word)
4)   Hardware drivers for various components (e.g printer)
5)   Web browser (e.g chrome)
6)   Barcode scanner soft ware

Technical
Skills I will need

1)   Operate PC +peripherals
2)   Ability to create and maintain a database
3)   Ability to manage a project

Operational


1)   We need an effective, reliable and accurate way to store details
2)   Must be an electronic Database management system
3)   Easily Accessible
4)   Easy to enter, alter, search, display, sort data.
5)   Access to schedule
6)   Ability to use genre headings
7)   Ability to look at performance details.
8)   Must operate in a busy environment.
9)   Ease of use
Financial

MAKE A BUDGET PLAN (See below)

Social and Ethical


1)   Use full business license, mindful of copyright.
2)   Privacy- not to share info with others
3)   Integrity- honest + accurate
4)  Insurance for software/hardware
5)  Security- Strict access for employees only.
6) Personal details remain confidential 
7) Changing the nature of work: Impact of both negative and positive on employees. They may need to train staff. 




Financial Budget Plan 




No comments:

Post a Comment