Home » Developer & Programmer » Designer » Help With A SQL Senario
Help With A SQL Senario [message #658917] Fri, 30 December 2016 15:25 Go to next message
SmileyBirdy
Messages: 3
Registered: December 2016
Junior Member
I need to create an ER Diagram for the Nothern Star Scenario in this link: http://users.humboldt.edu/smtuttle/s10cis492/492project_descriptions.pdf

I have generated the following list entities, I haven't added the attributes as yet

Staff Dept
Payroll Course Level
Employees
Adventure Type
Continent
Accommodation

Do these sound right?
Re: Help With A SQL Senario [message #658919 is a reply to message #658917] Fri, 30 December 2016 15:35 Go to previous messageGo to next message
BlackSwan
Messages: 25720
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

What does any of above have to do with Oracle SQL or PL/SQL?
Oracle provides no utility or tool to produce ER Diagram.

Post results from SQL below

SELECT * FROM V$VERSION;

Re: Help With A SQL Senario [message #658928 is a reply to message #658917] Sat, 31 December 2016 05:17 Go to previous message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
Well, to start with, you have forgotten to include a CUSTOMER entity. What does CONTINENT have to do with anything?
Better start again. Have you read the book yet?
https://www.amazon.co.uk/Casebook-Database-Processing-Fundamentals-Implementation/dp/0023668776
Previous Topic: Prefix on view
Goto Forum:
  


Current Time: Thu Nov 23 10:58:05 CST 2017

Total time taken to generate the page: 0.23638 seconds