#below is the SQL Script: You can copy and paste to runcreate database pharmacy;use pharmacy;create table branch (id int (3) not null auto_increment primary key, name varchar (50)not null);create table transaction_type (id int (1) not null auto_increment primary key, typevarchar (15) not null);create table network (id int (2) not null auto_increment primary key, name varchar (30)not null) ;create table worker (id int (3) zerofill not null auto_increment primary key, fnamevarchar (30) not null, Iname varchar (30) not null, contact varchar (13) not null);create table worker_branch (worker_id int (3) not null references worker (id),branch_id int (3) not null references branch (id), primary key (worker_id,branch_id));create table transaction (id int not null auto increment primary key, worker idint (3) not null references worker (id), branch_id int (3) not null, customer_novarchar (13) not null, customer_id int (25));You have been tasked to use the SQL script provided above by the database designer to explain how thesystem works by way of providing the following:1. The list of entities identified by the database designer.2. Provide an ER diagram indicating all the relationships using UML.3. Write query to insert the following records:a. Deposit and Withdrawal into the transaction_type table as types.b. Kumasi, Accra, Tamale, Bono Ahafo and Tema as branch names in the branch table.

List of entities indentified are: Branch, Transaction Type, Network, Worker, Worker Branch,…

varchar (13) not null, customer id int(25)); You have been tasked to use the SQL script provided above by the database designer to explain how the system works by way of providing the following: 1. The list of entities identified by the database designer. 2. Provide an ER diagram indicating all the relationships using UML. 3. Write query to insert the following records: a. Deposit and Withdrawal into the transaction_type table as types. b. Kumasi, Accra, Tamale, Bono Ahafo and Tema as branch names in the branch table.

varchar (13) not null, customer id int(25)); You have been tasked to use the SQL script provided above by the database designer to explain how the system works by way of providing the following: 1. The list of entities identified by the database designer. 2. Provide an ER diagram indicating all the relationships using UML. 3. Write query to insert the following records: a. Deposit and Withdrawal into the transaction_type table as types. b. Kumasi, Accra, Tamale, Bono Ahafo and Tema as branch names in the branch table.

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

All parts of this question use the following database schema: Flights(flno, from, to, distance) Aircraft(aid, aname, cruisingrange) Certified(eid, aid) Employees(eid, ename, salary) c) For each cruisingrange held by at least 3 aircraft, give the lowest salary of employees certified to fly one of those aircraft. Express in SQL only:
4. This question continues from Q3. (a) Write the insert SQL to populate the Zoom, BB, and the QR tables with the values given below. For each table, use only one insert to complete the insert task. The Duration column is initially empty. (b) Can you insert the ZOOM table first? Provide a reason according to the relational database theory if it is not possible. (c) Write a Delete SQL to remove student ‘M M’ from the BB table. If it is not possible to remove the row, provide a reason according to the relational database theory. You must not use SID in the SQL because only the name is given. (d) Write an Update DML that will compute and update the duration in minutesin the Zoom table. Show the updated table and the DML.
Using the relational database given in lab work no. 2, write the following queries in SQL: 1) How many different courses are there in each department? Sort the list. 2) How many students do have an advisor in the computer engineering faculty? 3) For each department, find out the highest CGPA of a student. Sort the list. (Add a new column to the student table!) 4) How many instructors are advising more than three students? 5) Which department has the highest number of students? 6) Which courses have multiple prerequisites? Sort the list. 7) How many different instructors taught the “Computer Programming” course at least two times? 8) Which instructor taught the “Object-Oriented Programming” course the most time? You should also present the output of each query in the lab report. _________________________________________________________________ The relational database schemas are as follows: department(dept-name, building, budget) instructor(ID, name, dept-name, salary) student(ID, name,…
use national join plz QI/ Consider the education database with student and school tables, where the primary keys are underlined. Give an expression in SQL for each of the following queries. Student(studentlID. full_name, sat_score, age, school_name) School(school name, street, city, country) 1- find the street and the city of all schools in England. 2- Find the school street, city, country, and the name of students who their school in 'West Carter' street. 3- Display the age and id of student that study in spanish. schools
I created a database that contains four tables department, employee,address and contact info, then I stored 5 Records in each table. by Writing the PL/SQL Statement I should retrieve departments and their employees using package.
You are working with a database table that contains invoice data. The table includes columns for invoice_id and billing_state. You want to remove duplicate entries for billing state and sort the results by invoice ID. You write the SQL query below. Add a DISTINCT clause that will remove duplicate entries from the billing_state column. NOTE: The three dots (...) indicate where to add the clause. SELECT ... FROM invoice ORDER BY invoice_id What billing state appears in row 17 of your query result? 1 point 1-CA 2-NV 3-WI 4-AZ
I need the answer as soon as possible
Please show all work and write it in PL/SQL and copypaste what you have.
Q1/ Consider the fruit database with fruit and market tables, where the primary keys are underlined. Give an expression in SQL for each of the following queries. Fruit(ID, fruit_name, fruit_color, price_KG) Market(market_name, city, street, fruit_name) 1- Find the names of all red fruits that has price less than 25 dinars. 2- Find the names of markets that sell banana in Atlanta city. 3- Find the name of fruits that has yellow color and sell in Glasgow market
Just answer question 10. I included the table