Sql using oracle

1. Database Design and Implementation Each group will choose an enterprise as your customer whom you will design a database for. Examples of an enterprise are bank, dealership, salon, bookstore, library, fashion shopping, working studio. You can make up your own customer of your interest. After you identify your customer, you need to analyze the situation of your customer, and list out the requirements/request from your customer. Conceptually design your database, i.e. the ERD. By drawing an ERD, you define all the entity sets and relationship sets in your database based on the information provide by the customer. Your ERD should model all information your customer requests to be included in the database Create your relational model based on the ERD. Now you should derive your relational schema for your database. Tune your relational schema. Identify FDs and make your database schema meet BCNF or Third Normal Form. Your decomposition should be lossless. In your final design, the number of tables, name of each table, attributes of each table, constraints, and etc., should be specified Create your database using SOL. the interface of your website. Queries should be created too for information retrieval from