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

ER Diagram Help | ER Diagram Assignment Help | ER Diagram Homework Help | ER Diagram Sample | Sample Homework
Assignment Help Features
- 24 x 7 Availability
- Plagiarism Free
- Trained and Certified Experts.
- Deadline Guaranteed
- Privacy Guaranteed
- Assignment Help Reward
- Online help for all project.
- Service for everyone
- Online Tutoring
- Free download.
- Free study help whitepapers
Assignment Help Services
- Assignment Help
- Homework Help
- Writing Help
- Academic Writing Assistance
- Editing Services
- Plagiarism Checker Online
- Proofreading
- Research Writing Help
- Services
Calculator