Distributed Database LAB Mid 2 29-2-2021 product P_id P_name description price Dell xps-13 Core is 1200 HP Envy 15 Core i7 1300 3 Lenovo ThinkPad x1 Core i7 2000 sales P_id sales t_cost date 4 4500 25-2-2021 2 2700 25-2-2021 5 5900 26-2-2021 2700 26-2-2021 3 5 7100 27-2-2021 1. Create database (Products) then create two tables (product) and (sales) with data as show above. 2. Create two users (Ahmed) and (Mena). Ahmed can display and update the product table while Mena can display and update both tables 3. Display product name, its sales and date (using inner join) 4. Display product name which has the maximum sales on 25-2-2021 (using subquery) 5. Display name and price of each product 2. 1. 2. 1. 1. 2.

Distributed Database LAB Mid 2 29-2-2021 product P_id P_name description price Dell xps-13 Core is 1200 HP Envy 15 Core i7 1300 3 Lenovo ThinkPad x1 Core i7 2000 sales P_id sales t_cost date 4 4500 25-2-2021 2 2700 25-2-2021 5 5900 26-2-2021 2700 26-2-2021 3 5 7100 27-2-2021 1. Create database (Products) then create two tables (product) and (sales) with data as show above. 2. Create two users (Ahmed) and (Mena). Ahmed can display and update the product table while Mena can display and update both tables 3. Display product name, its sales and date (using inner join) 4. Display product name which has the maximum sales on 25-2-2021 (using subquery) 5. Display name and price of each product 2. 1. 2. 1. 1. 2.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Discuss briefly the three phases of database design.
Discuss the challenges and considerations when choosing a NoSQL database for a project.
Database designs may be divided into two or three levels based on their specific needs, as is widely recognised. By moving to a three-tier database architecture, what advantages are gained? Discussbriefly
What exactly is database performance optimization and how does it work?
Draw Database Design (ERD & Related Notation) for car rental website as shown in the pictures
We have found that database architecture may be separated into two or three levels, depending on the needs, based on our previous experience with it. In what ways can moving from a two-tier to a three-tier design improve the design's characteristics? Discussbriefly
Describe the architecture of a NewSQL database system and how it combines elements of both traditional relational databases and NoSQL databases.
For Web-based application development, discuss any two database design issues in depth.
Describe the architecture and components of a distributed database query optimizer.
Draw Database Design (ERD & Related Notation) for car rental website as shown in the pictures
How do you design a database schema for a complex, real-world application? Discuss the normalization process and considerations for denormalization.
Discuss the concept of data warehousing and its role in database architecture.