OraFAQ Forum: Designer » Help With A SQL Senario

Home » Developer & Programmer » Designer » Help With A SQL Senario

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Help With A SQL Senario [message #658917]

Fri, 30 December 2016 15:25

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?

Report message to a moderator

Re: Help With A SQL Senario [message #658919 is a reply to message #658917]

Fri, 30 December 2016 15:35

BlackSwan
Messages: 26207
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;

Report message to a moderator

Re: Help With A SQL Senario [message #658928 is a reply to message #658917]

Sat, 31 December 2016 05:17

John Watson
Messages: 7622
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

Report message to a moderator

Previous Topic:	Prefix on view
Next Topic:	generate problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Oct 22 22:08:04 CDT 2018