JB Smalls, a recent graduate from Monroe College, has a strong entrepreneurial spirit and a love of music. Armed with his business degree in management, JB has decided to capitalize on his connections with the music and entertainment industry by amassing a collection of video sound bites for download. These short video segments are exclusive live performances from today’s most popular music artists and entertainers. JB believes these video bits are ideal for video ring tones, visual signatures, and a new trend in customized emoticons.
With grand ideas for a successful ecommerce site called vBits, JB knows the first step is to have a strong foundational database design and has come back to Monroe College seeking your expertise to do so.
Included are the artifacts necessary to develop a prototype design using Microsoft Access. Your job is to do just that referring to both the order tracking spreadsheet (artifact 01) and the additional attributes listed below (artifact 02). Specifically you are to do the following:
Using Microsoft Access, create a database named vBits_SName replacing “SName” with the first initial of your first name followed by your last name (i.e. vBits_JSmith.accdb).
Using both artifacts as your source documents along with your knowledge of database modeling (E-R diagrams, table notation, normalization, etc.), create FIVE (5) tables ensuring that all attributes are accounted for:
o Three(3) tables are derived from artifact01
o Two(2) tables are derived fom artifact02
Specify appropriate Data Types and Sizes for each of the fields.
Identify and set the Primary Keys (PK) for each of the tables thereby enforcing Entity Integrity.
Identify the Foreign Keys (FK) and then set the table relationships and enforce Referential Integrity.
Save and upload the completed database to Blackboard Dropbox.
Please note that you may find it easier to first layout your design on paper using E-R diagrams, table notation, etc. before building the database. Also note that the database should not contain any data. Just the schema.
Video Category ID
Client Street Address
Client Postal Code
Video Category ID
Client Balance Amount
Video Category Name
This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.
This is only a preview of the solution. Please use the purchase button to see the entire solution