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 Complex Queries Over Hospital Database
Homework Solution
$36.00
Computer Science
Database Development
Hospital Database
Complex Queries
Comparison
Measures
Subqueries
Tables
Constructions
Database For Birthdays and Interests
Homework Solution
$13.00
Computer Science
Database Development
Students
Birthdays
Interests
Primary Keys
Columns
Queries
Tables
Statements
Database Development Questions
Homework Solution
$100.00
Computer Science
Database Development
SQL Functions. Volunteer Activities
Strings
Names
Queries
Key Components
Discussion
Java Project for Transit System
Homework Solution
$10.00
Computer Science
Java Programming
Database Development
Transit System
Transactions
Destinations
Trips
Attributes
Weekly Schedule
Products
Data Flow Diagrams
Homework Solution
$56.00
Computer Science
Data
Flow Diagrams
Logic
Business
Operations
Processes
Systems
Activities
Entities
SQL Scripts
Homework Solution
$68.00
Computer Science
Database Development
SQL Scripts
Stored Procedures
Products
Users
Inventory
Codes
Backup
Get help from a qualified tutor
Live Chats