Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Project Description In this project, you will practice designing an application database system from scratch. You need pick a database application and design your own

Project Description In this project, you will practice designing an application database system from scratch. You need pick a database application and design your own database system with at least 5 entities. Your design will be composed of the following steps: 1. Describe the data requirements of your picked application 2. Draw an ER diagram for your design 3. Design relational schema based on your design (mapping ER schemas to relational schemas) 4. Pick a relational database management system such as Oracle, MySQL, SQL Server, create the tables and populate each table with at least 6 tuples 5. Design 8 queries, and express the queries in SQL or PL/SQL. Run the queries on the picked RDBMS present the result. At least 4 queries must involve 2 or more tables. Upon the completion, you need submit a written report for this project. The report should include every step of your design. More or less, your report serves as the documentation of the data requirement of your picked application database, and your design and development of the database. If time permits, you need give a 15-minute PowerPoint presentation about the project during the last month of the semester. Some sample applications Online car rental database. The database should contain customer information, location of company site for each city, different type of cars, rental price, available rental programs, promotions, as well as information about each rental transaction include pickup site, time, return site, time, payment, etc. Data on mutual fund companies, their offerings and portfolios within those offerings. A medical clinic database covering diseases, symptoms, diagnosis, drugs, patients, patient history, etc. Provision could be made for embedded X-Ray, MRI, ultra sound or other images. An on-line banking database (with customer, account, investment, loan, transaction information) A database for a health/auto/home insurance company Flight reserving system

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

Step: 3

blur-text-image

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

Graph Databases New Opportunities For Connected Data

Authors: Ian Robinson, Jim Webber, Emil Eifrem

2nd Edition

1491930896, 978-1491930892

More Books

Students also viewed these Databases questions