Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

MySQL minnstate edu/d2l/Me/content/4413070/viewContent/36868595/View The term project involves designing and implementing a database system for an organization. Each student has to work individually in this project,

MySQL image text in transcribed
image text in transcribed
minnstate edu/d2l/Me/content/4413070/viewContent/36868595/View The term project involves designing and implementing a database system for an organization. Each student has to work individually in this project, unless otherwise instructed in class. The term project is made up of a series of four deliverables, each building towards the finished product. Please remember that all deliverables must be submitted by midnight of the class day on the date they are due. Late deliverables will be penalized according to the late work policy, unless prior arrangements have been made. The project requires building a database application for a real-world scenario of your choosing. Some examples include: books, movies, music, computer games, geographical locations, genomic sequences, white water rafting resources, flights, etc. Note that you cannot choose the University database that is used in the text book nor the Customer-Invoice schema that is used in assignment 3. Try to pick an application that is relatively substantial, but not too big. For example, you might want your design to have in the range of 5 to 8 or so entities. You will design schemas for the database, and you will create an actual database using the MySQL relational Database Management System. You will populate the database with sample data, write interactive queries and modifications on the database, and develop user-friendly tools for manipulating the database. Step 1: What to submit? You are required to submit a one-page project description of your application. This is an initial, but reasonably well-thought out, one-page description of the database application you propose to work with throughout the course. You may state any assumptions you would like to make, Make sure your submission includes the following: 1 (10 points) One paragraph description of your application. View as load & Print Activity Details have viewed this ta ject Handout Step 1-ICS 311X C Home Chegg.com innstate.edu/d21/Me/content/4413070/viewContent/36868595/View Step 1: What to submit? You are required to submit a one-page project description of your application. This is an initial, but reasonably well-thought out, one-page description of the database application you propose to work with throughout the course. You may state any assumptions you would like to make. Make sure your submission includes the following 1 (10 points) One paragraph description of your application. 2 (5 points) The business explanation of at least 5 scenarios for queries that need to be answered using your database. E.g. 1. List names and due date of customers who checked out 'Harry Potter 2. List name and contact information for customers with past due books ie Print ad Activity Details ave viewed this ton 8A

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database 101

Authors: Guy Kawasaki

1st Edition

0938151525, 978-0938151524

More Books

Students also viewed these Databases questions

Question

How does economic profits differ from Financial Profits?

Answered: 1 week ago

Question

c. What were you expected to do when you grew up?

Answered: 1 week ago