Create Oracle database tables using SQL DDL
Required skills: SQL
Data Dictionary attached with ERD.
In this project you will perform the physical design and implementation using SQL Data Definition Language (DDL) and proceed with populating the Mom and Pop Johnson Video Store database via Data Manipulation Language (DML) SQL commands.
Project Details:
1. Create Oracle database tables using SQL Data Definition Language (DDL) for each table listed in Data Dictionary. Make sure that entity and referential integrity are enforced by declaring a primary key for each table (these may be composite keys) and declaring all appropriate foreign keys. Your CREATE TABLE statements must show integrity constraints, as appropriate, for NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, REFERENCES, and CHECK constraints. Be sure to save your script used to create these tables as yournameproject2step1.sql. You should test your script to make sure it runs without error.
2. Provide two examples of SQL DML (i.e., "INSERT") commands that fail different table integrity constraints you set up in one of your table. Explain why the statements fail. Be sure to save your script used to as yournameproject2step2.sql. You can include comments in the SQL script describing why the insert statements failed.
3. Populate each of your tables with at least five valid rows of data each and show the SQL you used. Populate other tables in your database, as necessary, to satisfy referential integrity. Be sure to save your script used to create these records as yournameproject2step3.sql. You should test your script to make sure it runs without error.
4. Write SQL to perform the following queries and updates. Be sure to save your script used to create these records as yournameproject2step4.sql. You should test your script to make sure it runs without error:
a. Retrieve all of your customers' names, account numbers, and addresses (street and zip code only), sorted by account number.
b. Retrieve all of the videos rented in the last 30 days and sort in chronological rental date order.
c. Produce a list of your distributors and all their information sorted in order by company name.
d. Update customer names to change their maiden names to married names. You can choose which records to update.
e. Delete customers from the database. You can choose which records to delete.
In this project you will perform the physical design and implementation using SQL Data Definition Language (DDL) and proceed with populating the Mom and Pop Johnson Video Store database via Data Manipulation Language (DML) SQL commands.
Project Details:
1. Create Oracle database tables using SQL Data Definition Language (DDL) for each table listed in Data Dictionary. Make sure that entity and referential integrity are enforced by declaring a primary key for each table (these may be composite keys) and declaring all appropriate foreign keys. Your CREATE TABLE statements must show integrity constraints, as appropriate, for NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, REFERENCES, and CHECK constraints. Be sure to save your script used to create these tables as yournameproject2step1.sql. You should test your script to make sure it runs without error.
2. Provide two examples of SQL DML (i.e., "INSERT") commands that fail different table integrity constraints you set up in one of your table. Explain why the statements fail. Be sure to save your script used to as yournameproject2step2.sql. You can include comments in the SQL script describing why the insert statements failed.
3. Populate each of your tables with at least five valid rows of data each and show the SQL you used. Populate other tables in your database, as necessary, to satisfy referential integrity. Be sure to save your script used to create these records as yournameproject2step3.sql. You should test your script to make sure it runs without error.
4. Write SQL to perform the following queries and updates. Be sure to save your script used to create these records as yournameproject2step4.sql. You should test your script to make sure it runs without error:
a. Retrieve all of your customers' names, account numbers, and addresses (street and zip code only), sorted by account number.
b. Retrieve all of the videos rented in the last 30 days and sort in chronological rental date order.
c. Produce a list of your distributors and all their information sorted in order by company name.
d. Update customer names to change their maiden names to married names. You can choose which records to update.
e. Delete customers from the database. You can choose which records to delete.
Posted In:SQL |
Related projects:
Create Oracle database tables using SQL DDL
ed by account number.
b. Retrieve all of the videos rented in the last 30 days and sort in chronological rental date order.
c. Produce a list of your distributors and all their information sorted in order by company name.
d. Update customer names to change their maiden names to married names. You can choose which records to update.
e. Delete customers from the database. You can choose which records to delete
b. Retrieve all of the videos rented in the last 30 days and sort in chronological rental date order.
c. Produce a list of your distributors and all their information sorted in order by company name.
d. Update customer names to change their maiden names to married names. You can choose which records to update.
e. Delete customers from the database. You can choose which records to delete
Create Oracle database tables using SQL DDL
tributors and all their information sorted in order by company name.
d) Update customer names to change their maiden names to married names. You can choose which records to update.
e) Delete customers from the database. You can choose which records to delete.
ii. Be sure to save your script used to create these records as yournameproject2step4.sql.
iii. You should test your script to make sure it runs without error:
d) Update customer names to change their maiden names to married names. You can choose which records to update.
e) Delete customers from the database. You can choose which records to delete.
ii. Be sure to save your script used to create these records as yournameproject2step4.sql.
iii. You should test your script to make sure it runs without error:
Create Oracle database tables using SQL DDL
tributors and all their information sorted in order by company name.
d) Update customer names to change their maiden names to married names. You can choose which records to update.
e) Delete customers from the database. You can choose which records to delete.
ii. Be sure to save your script used to create these records as yournameproject2step4.sql.
iii. You should test your script to make sure it runs without error:
d) Update customer names to change their maiden names to married names. You can choose which records to update.
e) Delete customers from the database. You can choose which records to delete.
ii. Be sure to save your script used to create these records as yournameproject2step4.sql.
iii. You should test your script to make sure it runs without error:
Create Tables
nts will not make a difference. For example, to drop a table named customer you would state:
DROP TABLE CUSTOMER CASCADE CONSTRAINTS;
After testing and verifying that all of your create statements work, create a spooled output file with the SET ECHO ON session command set so that your code and the results will show.
Deliverables for this task:
Task 2 comprised of the CREATE TABLE script file and the output file showing that it works.
DROP TABLE CUSTOMER CASCADE CONSTRAINTS;
After testing and verifying that all of your create statements work, create a spooled output file with the SET ECHO ON session command set so that your code and the results will show.
Deliverables for this task:
Task 2 comprised of the CREATE TABLE script file and the output file showing that it works.
Web Page That Queries An Oracle Database 2 2
boxes for the foreign keys fields. It will also run predefined queries. I will do the work but I need some assistance with how to set up the page to do this. I need sample code to have the page do this and retrieve the data from the database.
Additional Info (Added 4/25/2011 at 1:52 EST)...System Message: This is a reposting of project Web page that queries an Oracle database 2 (1302903254).
Additional Info (Added 4/25/2011 at 1:52 EST)...System Message: This is a reposting of project Web page that queries an Oracle database 2 (1302903254).
Web Page That Queries An Oracle Database 2
nd the web page should allow users to input data into the tables employing drop down boxes for the foreign keys fields. It will also run predefined queries. I will do the work but I need some assistance with how to set up the page to do this.
Additional Info (Added 4/18/2011 at 10:37 EST)...System Message: This is a reposting of project Web page that queries an Oracle database (1302663004).
Additional Info (Added 4/18/2011 at 10:37 EST)...System Message: This is a reposting of project Web page that queries an Oracle database (1302663004).
Web Page That Queries An Oracle Database 2
roject I'm working on. I have created an Oracle database and I'm creating a web page that queries data from it. I have connected to the dBase with a JAVA servlet and the web page should allow users to input data into the tables employing drop down boxes for the foreign keys fields. It will also run predefined queries. I will do the work but I need some assistance with how to set up the page to do this. I need sample code to have the page do this and retrieve the data from the database.
Web Page Connected To Oracle Database
class and connecting to a database that I created. I am connected with putty and WinSCP. I will do the work on this because it is a class aswsignment. I just need assistance with explaining me through the rough parts. There are 3 more weeks of class and I have completed the database part already. I have been given the instructions but it's not working. I may have other questions in completing the project. Like, how is the web page actually requesting the info from the dBase, etc.
Complete a Simple SQL/Oracle database (College Assigment)
tored procedures) with comments to explain what each part of the codes does.
So basically the ER Diagrams and the database has already been made. You just have to check what i have done is correct, discuss with me and make changes. Then do the 3 sql queries and the 3 PL/sql.
I want this completed in two days and it shouldnt take a pro longer, so bids should be $ 20 max .
Thanks
So basically the ER Diagrams and the database has already been made. You just have to check what i have done is correct, discuss with me and make changes. Then do the 3 sql queries and the 3 PL/sql.
I want this completed in two days and it shouldnt take a pro longer, so bids should be $ 20 max .
Thanks
Oracle Sql
ogram guide should have enough programs
for various channels to support the program guide report)
• Other tables: A sufficient amount of data to support the above when reports are run
Show each query and its output in your submission (you will have a minimum of six queries).
To submit this task, create a heading REPORTING STATEMENTS in the SQL document and create a
spooled or HTML output of your queries and the result set for each.
for various channels to support the program guide report)
• Other tables: A sufficient amount of data to support the above when reports are run
Show each query and its output in your submission (you will have a minimum of six queries).
To submit this task, create a heading REPORTING STATEMENTS in the SQL document and create a
spooled or HTML output of your queries and the result set for each.
Oracle Database Design
>
Additional files submitted: (Files are only available for logged in users)
Projects+.doc
project+1+requirements.doc
Additional files submitted: (Files are only available for logged in users)
Projects+.doc
project+1+requirements.doc
Oracle database on your own conception and design
ou may design your own application function. Show video/music to the webpage by storing the Large Object in the oracle. (Each application coding should be keep in *.txt file/notepad that able to be executed). add a trigger to system (20%)
Create a simple manual to your product. During the 1 week before the assignment due date, you will be required to demonstrate the application interfaces.
Create a simple manual to your product. During the 1 week before the assignment due date, you will be required to demonstrate the application interfaces.
ERD&Use case, ORACLE Database/ SQL queries + Report Writing
cessful bid) :
Management Report writing + few descriptions ( about 1600 words)
Use Case Modelling & ERD Development using UML (full specifications for each Use Cases[2 or 3] and brief report/presentation of all)
Oracle Database in ORACLE 11g & SQL Queries creation
+commentaries on what was done
The whole project and some instructions will be sent after a successful bid
It should take about 10-15 hours
Management Report writing + few descriptions ( about 1600 words)
Use Case Modelling & ERD Development using UML (full specifications for each Use Cases[2 or 3] and brief report/presentation of all)
Oracle Database in ORACLE 11g & SQL Queries creation
+commentaries on what was done
The whole project and some instructions will be sent after a successful bid
It should take about 10-15 hours
Oracle Database project
Hi all,
Require help with Oracle Database assignment.Oracle SQL*Plus and Oracle Developer Suite for this.Please message me for further details.Due date is Saturday, May 19,2012
Regards,
Require help with Oracle Database assignment.Oracle SQL*Plus and Oracle Developer Suite for this.Please message me for further details.Due date is Saturday, May 19,2012
Regards,
SQL Server Business Intelligence Development Studio
in SQL Server 2008 to build the dim and fact tables. This is a very small database project that involve 10 tables (before creating the data warehouse). Quite a simple and straight forward project and involves small data. More detail explaination in the attachment.
Please dont expect a high pay since this is a very small project, and please don't bid if you can't deliver in less than 5
days.
Thanks and happy bidding.!
Please dont expect a high pay since this is a very small project, and please don't bid if you can't deliver in less than 5
days.
Thanks and happy bidding.!
XML Data Transfer from MS SQL Server to Oracle Database
ild a system to transfer data (using XML) from SQL Database to Oracle. Given the scope for future development the data should be first converted to XML and then transferred. At the receiving end the data should be converted back to records from XML and then saved as records(application) in Oracle database.
Only bid if you can do the job.
Matt
Only bid if you can do the job.
Matt
Building The Physical Model
ng and verifying your script
Now we come to the point of verifying that your script file works by creating all of the tables and inserting all of the data. To verify this you will need to create a output file and capture the results being returned to the session by using the spool COMMAND outlined in the tutorial "Using Oracle SQL*Plus". This output file will be one of the files you will be turning in for grading.
This is the end of lab #3
Now we come to the point of verifying that your script file works by creating all of the tables and inserting all of the data. To verify this you will need to create a output file and capture the results being returned to the session by using the spool COMMAND outlined in the tutorial "Using Oracle SQL*Plus". This output file will be one of the files you will be turning in for grading.
This is the end of lab #3
Building The Physical Model
ng your script
Now we come to the point of verifying that your script file works by creating all of the tables and inserting all of the data. To verify this you will need to create a output file and capture the results being returned to the session by using the spool COMMAND outlined in the tutorial "Using Oracle SQL*Plus". This output file will be one of the files you will be turning in for grading.
This is the end of lab #3
Now we come to the point of verifying that your script file works by creating all of the tables and inserting all of the data. To verify this you will need to create a output file and capture the results being returned to the session by using the spool COMMAND outlined in the tutorial "Using Oracle SQL*Plus". This output file will be one of the files you will be turning in for grading.
This is the end of lab #3
Iphone And Bb Product Search App Using Sql Or Excel Database
le.textDecoration='underline'" onmouseout="this.style.textDecoration='none'">http://www.qualmax.com/product_search_test.php)
It would also include introduction page about the company and direct link to pop-up call and pop-up email. The apps should look highquality and userfriendly for the company image.
Please inform which apps you have developed in the past so I could get a basic idea of your experience.
Thank you.
Paul
It would also include introduction page about the company and direct link to pop-up call and pop-up email. The apps should look highquality and userfriendly for the company image.
Please inform which apps you have developed in the past so I could get a basic idea of your experience.
Thank you.
Paul
VB.Net client App Required with webcam and oracle database
h deliverable and one for the integrated UAT (3+1).
Responsibilities
We will provide the Oracle DDL with tables, views and stored procedures.
You will devlop, test and provide the necessary files to ensure we can perform user acceptance testing.
Non-Disclosure Agreement required before work can commence.
Please provide delivery dates and examples of work...relevant work...not just websites.
Any further question please ask.
Responsibilities
We will provide the Oracle DDL with tables, views and stored procedures.
You will devlop, test and provide the necessary files to ensure we can perform user acceptance testing.
Non-Disclosure Agreement required before work can commence.
Please provide delivery dates and examples of work...relevant work...not just websites.
Any further question please ask.
