Data Base's

02/01/2016 | | Memorandum |

| | |

ToJosh JostFromCarrie GriffithCCUniversity of PhoenixReCC Museum | | |

CC Museum is a fine arts museum similar to the Art Institute of Chicago. The Corporation has grown aggressively over the past three years. The database needs to be expanded so that it can with stand the growth. Also, CC Museum has implemented a new customer base, by allowing customers to sell fine works of art to CC Museum. They are now allowing customers to have online access. So, this will require security to be paramount. The upgrade to the documentation system must be fast, secure and consistent. CC Museum requires high regard to attention inside the data center. Privacy and Security of information is to be well thought out through the entire future of this project.

When an object arrives at CC Museum, it begins a “New Life”: it will be assigned an accession number which will organize all details of that object. For this reason a primary key (PK) key will be assigned to the accesion_id which will track the object through all aspects of the database. The PK, will minimize redundancy inside the system. The same aspect will exist inside the customer base. When a customer makes purchases or sells to CC Museum, they will be assigned a customer_id, which will allow instant access. The details of the accesion_id and the customer_id will be listed as foreign keys (FK). Such as, a table called customer has a primary key called customer_id. Another table called employee details will be assigned the (FK) in order to uniquely identify the relationship between both tables. For added security the "Barracuda Firewall" will be added to the database, all customers and employees will be authenticated before logging on.

Our team has devised an entity relationship model or diagram that will explain and assist the business to fully understand the process to be implemented at CC Museum. This will bring competitive advantage and business...