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

ER Diagaram Assignment Help Order Now

ER Diagram for Business Book Library

List The Requirements Of The Business Book Library Database Design

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

TABLE FOR Student

table for student

TABLE FOR Lone

table for lone

TABLE FOR Author

table for author

TABLE FOR Book

table for book

TABLE FOR Category

table for category

TABLE FOR Publisher

table for publisher

SQL Queries

SQL SELECT DISTINCT Statement

DISTINCT Statement

SQL WHERE Clause

sql where clause

SQL OR Operators

SQL OR Operators

ER Diagaram Help | ER Diagaram Assignment Help | ER Diagaram Homework Help | ER Diagaram Sample