Find Jobs
Hire Freelancers

Databaze PROJECT - repost

€8-30 EUR

Abgeschlossen
Veröffentlicht vor etwa 10 Jahren

€8-30 EUR

Bezahlt bei Lieferung
Consider the database of an online business selling DVD, which stores the sales and orders . The relational schema of the database appearing on the next page . As shown in the figure, NW stores information for following :  The different titles DVD (Products) that the firm has . each title belongs to a class .  Clients (Customers) of the business. For each customer stored personal data (name , surname , etc. ) , credit card (type, number , expiration date ) and data access to online business (username, password).  orders (Orders) that makes every client of the firm , for which saved the order date , the pre-tax amount , tax , and total amount of each order .  The products contained in each order (Orderlines) the amount of any product and date order. You are given a large data set (dataset) real ( anonymised ) data. On this, run the following questions : Question 1 ( 50 % ) . Relational vs. Object- relational databases (a) Enter the above data into a properly designed NW in DBMS which you wish (PostgreSQL or Oracle). The NW at this stage will follow necessarily the relational schema as given to you. The deliverable sub-question is the commands and files used for data entry and screenshots that will show their paintings the DB loaded with data . (b) Then anaschediaste the above relational schema using the object- relational model . For the conceptual description of the new shape please provide the UML class diagram of the DB . After creating the appropriate collections , complex data types and tables they contain , Implement appropriate PL / SQL scripts to provision the object- relational schema of the data sub-question 1 (a). The deliverable sub-question is the PL / SQL scripts needed to create the complex data types , the object- relational tables and uploading data from their respective relational . (c) Perform the following questions (queries) in the relational DB , having set where and if necessary, appropriate indexes. i. "Who is the one (or several in case of a tie ) customer with the highest total value of orders ? " The result will show 2 columns : client code , total value of orders. ii. "Who are the customers who have made at least one order containing DVD of at least 3 categories ? " The result will appear 2 columns: customer number , order number ( with at least 3 categories DVD). iii. "What is the total value of orders per month , country and category products ? '. This result will be shown 4 columns: Month , country name category , total value of orders. (d) Perform the questions sub-question 1 (c) the object - relational DB that graphed in sub-question 1 (b). Expand composite objects object - relational DB with appropriate methods (object methods), they're necessary to support the resolution of these questions. The Reply to this sub-question will include , for each query: screenshot by PL / SQL block to be followed by an appropriate justification and the screenshot results obtained. (e) Identify , analyze and explain the differences in performance execution of queries , consulting and implementation plans (query plans) producing each system (using the command EXPLAIN). Question 2 ( 35 % ) . Records and Indexes , Processing & Optimization Question The relations Customers, Orders, Orderlines apply the following assumptions : (i) the number of tuples of the relation is Orderlines ROrderlines = 60.350, (ii) the number of tuples of Orders relationship is ROrders = 12.000, (iii) the number of tuples of the relation Customers is RCustomers = 20.000, (iv) the page size disk (block) is b = 4.000 bytes. Now consider the following SQL query : SELECT * FROM Customers AS C, Orders AS O, Orderlines AS OL
Projekt-ID: 5398907

Über das Projekt

1 Vorschlag
Remote Projekt
Aktiv vor 10 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
Vergeben an:
Avatar des Nutzers
HI Contact me for an efficient, well documented and perfect solution and development of your project. I ensure quality work with always on time delivery of project and dedicated support and follow up. Thanks Farah Saif
€52 EUR in 1 Tag
5,0 (59 Bewertungen)
5,4
5,4
1 Freelancer bieten im Durchschnitt €52 EUR für diesen Auftrag
Avatar des Nutzers
hi sir. I am able to do the project for free. The reason I do this is that I am new freelancer and i need to earn prestige as well as a long-term employer. If you decide hire me you will not regret regards from cuba leisniel
€24 EUR in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von GREECE
Argos, Greece
5,0
1
Mitglied seit Feb. 4, 2014

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.