Answered: Mr. Emmanuel Kwame Andoh wants to start…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

100%

Mr. Emmanuel Kwame Andoh wants to start a mobile money vending business with 6 branches across the country. He wants to be able to have information on all the transactions that happens in any of his branches. He describes a typical daily activity per a worker as follows: A customer or a person walks in and requests to do either a withdrawal or a deposit. Then his worker would record the name and number of the person, the type of transaction and the amount involved in the transaction and the transaction reference number. Mr. Andoh provided all the information above and more to a database designer who simply supplied just the SQL script that would implement the system. But the designer did not explain how the system would work to Mr. Andoh. #below is the SQL Script: You can copy and paste to run create 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,type varchar(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, fname varchar(30) not null, lname 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_id int(3) not null references worker(id), branch_id int(3) not null, customer_no 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.

Expert Solution