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

What are multivalued attributes,and how can they be handled within database design?
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?
What are the most important decisions to be made in physical databases architecture ?
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.
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.
Our knowledge of database design tells us that depending on the needs, it may be split into two or three levels By switching from a two-tier design to a three-tier design, what qualities are gained? Discussbriefly