Sample: Relational Schema of the ER diagram

Question

Have a one page summary business scenario. Identify the business rules and assumptions. –

Create an ER diagram; it must have at least 6 tables. -Create the relational schema of the ER diagram. -Create the SQL script that creates tables in SQL Plus or 10g *Make sure the ERD, schema and SQL table definition script are consistent -Create SQL queries- 2 must be sub queries, 2 inner joins, 2 outer joins

Answer

Take the example for Business Book Library for making ER- Diagram with 6 table

List The Requirements Of The Business Book Library Database Design

• Student
• Lone
• Author
• Book
• Category
• Publisher

TABLE FOR Student

TABLE FOR Lone

TABLE FOR Author

TABLE FOR Book

TABLE FOR Category

TABLE FOR Publisher

SQL Queries

SQL SELECT DISTINCT Statement

SQL WHERE Clause

SQL OR Operators