Question

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.

Artifact 01
Order ID
Date Ordrered
Client ID
Video Number
Description
Video Category ID
Standard Price
Quantity Ordered
Order Price

Artifact 02
Client ID
Client Phone
Client Name
Client Email
Client Street Address
Client State
Client City
Client Postal Code
Video Category ID
Client Balance Amount
Video Category Name

Solution Preview

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.

Database Development Questions

This is only a preview of the solution. Please use the purchase button to see the entire solution

Assisting Tutor

Related Homework Solutions

SQL Server for Business Intelligence
Homework Solution
$23.00
SQL
Server
Business
Intelligence
SSAS
Data
Mining
MDX
DAX
Role
Named
Multidimensional
Model
Analysis
Services
Holdout
Set
Lift
Chart
Prediction
Query
Named
KPI
Calculated
Column
Measure
Tabular
Row
Filter
Context
BI
Data Normalization
Homework Solution
$98.00
SQL
Normalization
Computer
Science
Database
Development
Dependencies
Keys
Table
Primary
Foreign
Database Development Questions
Homework Solution
$20.00
Database
Design
Implementation
Computer Science
Models
Foreign Keys
Tables
Medicine
Diagnosis
Functional Dependencies
Paid Date
Get help from a qualified tutor
Live Chats