Oracle SQL In Virtual Machine COMP269

Running head: DATABASE DESIGN USING ORACLE SQL IN VIRTUAL MACHINE
DATABASE DESIGN USING ORACLE SQL IN VIRTUAL MACHINE
Name of t …

Preview text

Running head: DATABASE DESIGN USING ORACLE SQL IN VIRTUAL MACHINE
DATABASE DESIGN USING ORACLE SQL IN VIRTUAL MACHINE
Name of the Student:
Name of the University:
Authors Note:
1 DATABASE DESIGN USING ORACLE SQL IN VIRTUAL MACHINE
Table of Contents
Part A: Single and multiple queries ………………………….. ………………………….. ……………………… 3
Questions 1 – 5: ………………………….. ………………………….. ………………………….. ……………………… 3
Initial database creation and getting access ………………………….. ………………………….. ………… 3
Answer 1: ………………………….. ………………………….. ………………………….. …………………………. 3
Answer 2: ………………………….. ………………………….. ………………………….. …………………………. 3
Answer 3: ………………………….. ………………………….. ………………………….. …………………………. 4
Answer 4: ………………………….. ………………………….. ………………………….. …………………………. 5
Answer 5: ………………………….. ………………………….. ………………………….. …………………………. 6
Question 6: ………………………….. ………………………….. ………………………….. ……………………….. 7
Answer 6: ………………………….. ………………………….. ………………………….. …………………………. 7
Part B: Table and advance queries ………………………….. ………………………….. ……………………….. 8
Answer 1: Creating database and tables ………………………….. ………………………….. …………….. 8
Answer 2: Inserting data into Occurance_Excercise table ………………………….. ………………… 9
Answer 3: ………………………….. ………………………….. ………………………….. ……………………….. 11
Answer 4: ………………………….. ………………………….. ………………………….. ……………………….. 11
Part C: Queries on the Library Database ………………………….. ………………………….. …………….. 11
Answer 1: Five most popular books ………………………….. ………………………….. ………………… 11
Answer 2: Branches having no Loans ………………………….. ………………………….. ……………… 12
Answer 3: Longest time book has been on loan ………………………….. ………………………….. … 12
Answer 4: Borrower returned book on 16 Dec, 2010 and 8 May 2012 …………………………. 13
2 DATABASE DESIGN USING ORACLE SQL IN VIRTUAL MACHINE
Answer 5: Query for eliminating duplicate queries ………………………….. ……………………….. 14
Bibliography ………………………….. ………………………….. ………………………….. ………………………. 16
3 DATABASE DESIGN USING ORACLE SQL IN VIRTUAL MACHINE
Part A: Single and multiple queries
Questions 1 – 5:
Initial database creation and getting access
Create table Borrower as select * from jtutty.Borrower;
Create table book as select * from jtutty.book ;
Create table branch as select * from jtutty.branch;
Create table loan as select * from jtutty.loan;
Answer 1:
Select lname, cardno from borrower
Where cardno 1
WITH cte AS (
15 DATABASE DESIGN USING ORACLE SQL IN VIRTUAL MACHINE
SELECT invoice_no, invoice_date
rn = row_number() OVER(PARTITION BY invoice_no, invoice_date ORDER BY
invoice_no) AS [rn]
FROM Invoice
)
DELETE cte WHERE [rn] > 1
16 DATABASE DESIGN USING ORACLE SQL IN VIRTUAL MACHINE
Bibliograp hy
Alam, M.I., Halder, R. and Pinto, J.S., 2021. A deductive reasoning approach for database
applications using verification conditions. Journal of Systems and Software , 175 , p.110903.
Jaja, A.I. and Bennett, E.O., 2018. Enforcement of Partial Referential Integrity in a Database
System. International Journal of Computer Science and Mathematical Theory , 4(2), pp.27 –
33.
Masson, T., Ravet, R., Ruiz, F.J.B., Serbout, S., Ruiz, D.S. and Cleve, A., 2020, January.
Defining Referential Integrity Constraints in Grap h-oriented Datastores.
In MODELSWARD (pp. 409 -416).
Rahman, H., 2020. Oracle Database Design and Development in Ador Composite Ltd.
Sadeq, M.J., Rayhan Kabir, S., Akter, M., Forhat, R., Haque, R. and Akhtaruzzaman, M.,
2021. Integration of blockchain and r emote database access protocol -based database.
In Proceedings of Fifth International Congress on Information and Communication
Technology (pp. 533 -539). Springer, Singapore.
Tian, J., Braithwaite, D.W. and Siegler, R.S., 2021. Distributions of textbook pro blems
predict student learning: Data from decimal arithmetic. Journal of Educational
Psychology , 113 (3), p.516.
Velmurugan, L. and Manoharan, S., 2020. Designing Factors of Distributed Database
System: A Review. CiiT, International Journal of Data Mining a nd Knowledge
Engineering , 12 (1).
Vinayagamurthy, D., Gribov, A. and Gorbunov, S., 2019. StealthDB: a Scalable Encrypted
Database with Full SQL Query Support. Proc. Priv. Enhancing Technol. , 2019 (3), pp.370 –
388.
17 DATABASE DESIGN USING ORACLE SQL IN VIRTUAL MACHINE

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more