Sample queries based on logical field names would work. Here are all the questions: also is there a way for me to upload a file to you?
You are expected to write SQL request sequences for 15 situations (use cases). Ten of these fifteen situations are described below. The remaining five you will devise yourself, based on reasonable business operations. The solution should be DML (SELECT, INSERT, UPDATE, or DELETE) statements or sequences of DML statements. You can place a COMMIT statement at the end of the sequences of DML statements which implement business transactions. The sequences of DML statements may be terminated by a commit, if the use case situation is a business transaction. Some of the situations below will require more than one SQL statement.
Do you have a database in Access or something that I can use to verify the query syntax? That would make this much easier. You can upload via Wikisend as I mentioned in my previous post.
Here you go. Without a database or schema to test these on, I can't be 100% sure of the syntax, but this should be very close.
You can download from here:
What's the difference between the conceptual and logical ERD?
And the Create Database scripts would be in SQL Server, not Oracle. I am a SQL Server guy...
Logical should be fine, since it's the one that would contain the primary and foreign keys and attributes. Also sql is fine because that what we use even for Oracle. Project link attached:
Hi Jeff, here's a payment for the initial question. Please let me know if you can create the ERD and database script as well and I will make an additional payment on that?
How soon do you need it?
By midnight Sunday (PST).
Unfortunately, due to a major project at my regular job with a go-live scheduled for next Monday, I won't have time to create the ERD & database scripts for you. I suggest you post another question on JA to see if another expert can get that done for you.