View the step-by-step solution to:

Part 2 Overview In Part 1 you "pitched" your idea for your database. Here in Part 2 you will submit a "design" For Part 3 you...

I need the second part of my assignment completed by creating an E-R diagram in Vizio or Word and some sample data for each table.  The first part of the assignment will support the diagram created.  Attached is the first part of my assignment and the second part.  I will soon need the third part completed as well :)  Thanks in advance.

Part 2 Overview In Part 1 you "pitched" your idea for your database. Here in Part 2 you will submit a "design" For Part 3 you will submit the final Access Database Database Design - E-R Diagram (50 points) Provide a picture of the database design (E-R diagram) using Visio or Word. Sample Data - (50 points) Provide 2-3 rows of sample data for each table (Note: Excel may be a great tool to use by using 1 worksheet per table and the first row has the column names - also because Access can Import from Excel very well)
Background image of page 1
CISY 211 – Project Part 1 Name: George Lawler 1. What is the purpose of the database? The proposed database is for an online movie store that enables customers to buy movies online. The purpose of the database is record data about the various movies available for sale, the customers, and keep track of all transac±ons. Development of the database is to enable easy management of data in terms of delete, update and add new data on the movies and customers. 2. Who is the target audience? (it is ok if it is you) The target of this system is individuals who wish to access diverse movie collec±on online. I have personally had a problem accessing latest movies because to purchase a movie meant visi±ng the local movie store across the street which lacked variety and latest movies. Availability of an online movie store provides a be²er experience where I can purchase a movie from the comfort of my room. 3. What tables do you envision? (For now, just a list of major tables [ Order, Customer, Product ], In Part 2 a detailed design will be provided) The proposed system will have a database named MovieStore. The database will comprise of several tables that will be connected to ensure eFcient data retrieval. The database will comprise of the following major tables: Movies: This table store all the movies available at the movies store. Customers: This table will contain customer-speci³c details such as customer name, billing address, phone number etc. Movie_details: This table with store speci³c informa±on about a par±cular movie such as movie name, crew, type, cast, similar movies etc. Orders: This table will contain the data about all the orders made by the customers. 4. What kinds of queries or reports do you envision? (for now, just a brief list with brief descripTons [ Customers who owe money, Customers who purchased the most, Products Purchased the most, Products purchased the least], Part 2 is the detailed design) Queries are used to extract speci³c informa±on from the tables. Some of the queries that will be used in this system are: SELECT * ´ROM Movies: This SELECT command is used to display all movies stored the movies table. DELETE: This command in a query is used to delete an item from a table in the database as speci³ed by the query. qa²achments_152e6540f695dd0352b3d30f89c4fce4324a77ca.docx 1
Background image of page 1
CISY 211 – Project Part 1 5. What “primary” updates and deleTons do you envision as being regular updates for the database? [update order, delete order?, ] For a database that contains frequently changing data is subject to update and deleTon of some data. Example of updates include, customer details, order update and movie update. On the other hand, deleTon can include, deleTng incomplete orders, deleTng a customer, or deleTng a move. 6. What volume of data do you plan for this project? [in the end, you will need enough data to produce meaningful reports - could be in the teens or dozens] ±he data contained in this database will grow as new movies are released and customers make purchases. ±o be able to provide viable reports the tables will be populated with at least ²³y entries. ±his amount of data will be enough to test database e´ciency and table relaTons. 7. What volume of data would you have for the real world? Real world data is expected to be huge and thus the database will require to be tested ²rst with large volumes of data to determine its applicability. ±he database is expected to handle more than ten thousand transacTons in a day once it is deployed in the real world. qaµachments_152e6540f695dd0352b3d30f89c4fce4324a77ca.docx 2
Background image of page 2
Sign up to view the entire interaction

Top Answer

Done, for consistency of your work... View the full answer

Database Design.vsd

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.


Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online