Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started