The relational database below contains details about Keretapi Tanah Melayu Berhad (KTMB) train journeys from Kuala Lumpur Sentral to various destinations in Malaysia: TRAIN (trainCode, trainName, trainCapacity, trainModel) JOURNEY (journeyID, trainCode, stationCode, ageCategory, ticketPrice) STATION (stationCode, stationName, stationDistance) a. Create table JOURNEY. b. Every ticket need to be increase 20% from the current price. Modify the price. С. Find the names of all stations within 100 kilometers from Kuala Lumpur Sentral.

The relational database below contains details about Keretapi Tanah Melayu Berhad (KTMB) train journeys from Kuala Lumpur Sentral to various destinations in Malaysia: TRAIN (trainCode, trainName, trainCapacity, trainModel) JOURNEY (journeyID, trainCode, stationCode, ageCategory, ticketPrice) STATION (stationCode, stationName, stationDistance) a. Create table JOURNEY. b. Every ticket need to be increase 20% from the current price. Modify the price. С. Find the names of all stations within 100 kilometers from Kuala Lumpur Sentral.

Fundamentals of Information Systems

9th Edition

ISBN:9781337097536

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter3: Database Systems And Big Data

Section: Chapter Questions

Problem 4PSE

See similar textbooks

Similar questions

Create the table that results from applying an INTERSECT relational operator to the tables shown in Figure Q3.13. FIGURE Q3.13 THE CH03_VENDINGCO DATABASE TABLES
How is the processing of SQL DDL statements (such as CREATE TABLE) different from the processing required by DML statements?
This assignment is aimed at building an understanding of how to improve performance within databases by taking advantage the computers hardware by modifying MS SQL settings Prerequisites: Completion of Assignment 1B, reading of Module Readings and Slides. Run the following query to understand how much Memory is currently in use in the database: SELECT physical_memory_in_use_kb/1024 AS sql_physical_memory_in_use_MB, large_page_allocations_kb/1024 AS sql_large_page_allocations_MB, locked_page_allocations_kb/1024 AS sql_locked_page_allocations_MB, virtual_address_space_reserved_kb/1024 AS sql_VAS_reserved_MB, virtual_address_space_committed_kb/1024 AS sql_VAS_committed_MB, virtual_address_space_available_kb/1024 AS sql_VAS_available_MB, page_fault_count AS sql_page_fault_count, memory_utilization_percentage AS sql_memory_utilization_percentage, process_physical_memory_low AS sql_process_physical_memory_low, process_virtual_memory_low AS…
Referring to Appendix A below, code a MySQL statement to display the sales order number and customer name for all sales orders. APPENDIX A – Table definitions and initializations-- MySQL script to initialize a MySQL database and four tables:-- customer, detail, item, salesorder--DROP DATABASE IF EXISTS finaldb;CREATE DATABASE finaldb;USE finaldb;CREATE TABLE customer ( c_num varchar(16), c_name varchar(128));CREATE TABLE detail ( d_onum varchar(16), d_inum varchar(16), d_qty int);CREATE TABLE item ( i_num varchar(16), i_name varchar(128), i_price decimal(9,2), i_qty int);CREATE TABLE salesorder ( s_num varchar(16), s_cnum varchar(16), s_date date);INSERT INTO customer VALUES ('c101','Sam Paint'), ('c102','Ramon Hardware'), ('c103','Li Auto');--INSERT INTO detail VALUES ('s201','i301',21), ('s201','i302',22), ('s202','i302',23), ('s202','i303',24), ('s203','i303',25), ('s203','i304',26);--INSERT INTO item VALUES…
A relational database has the following schema: Customer (Cno, name, address, age, loan_type, loan_amount, year) Solve following queries in relational algebra: Select the records where loan_type is 'Personal'. Select the records where age is geater than 30 and loan_type is ‘soft’. Select records from Customer table where loan_type is ‘Personal' and loan_amount is Rs200000 or those customers who opened an account after 2017. Project the columns name and address from the Customer table.
Customers (id, name, shops_id)Products (id, name, price, manufacturing_company)Orders (id, customers_id, products_id, total_bill)Employees (id, name, designation, current_salary)Salaries (id, employees_id, salary, month)Shops (id, name)Branches(id, shops_id, branch_name, address, city)Consider the above designed database schema and write SQL commands\ queries to answer the followingquestions:• Write SQL query to create 2 instances of any table designed.INSERT INTO Shops(name) VALUES("Mirpur Medical Store"),("F3 Medical Store");• Name of customers along with their Ids who have placed order of amount more than 10000 to thecompany.SELECT distinct c.id,c.name FROM Customers AS c JOIN Orders AS o ON c.id = o.customers_id WHEREo.total_bill > 10000;• Give managers the 5% increase in salary.UPDATE Employees SET current_salary = (current_salary + (current_salary * 5)) WHERE designation ='manager';• Three top customers (names) in terms of total purchase made by them. List is to be in…
Referring to Appendix A below, code a MySQL statement to display the item number and name for all items. APPENDIX A – Table definitions and initializations-- MySQL script to initialize a MySQL database and four tables:-- customer, detail, item, salesorder--DROP DATABASE IF EXISTS finaldb;CREATE DATABASE finaldb;USE finaldb;CREATE TABLE customer ( c_num varchar(16), c_name varchar(128));CREATE TABLE detail ( d_onum varchar(16), d_inum varchar(16), d_qty int);CREATE TABLE item ( i_num varchar(16), i_name varchar(128), i_price decimal(9,2), i_qty int);CREATE TABLE salesorder ( s_num varchar(16), s_cnum varchar(16), s_date date);INSERT INTO customer VALUES ('c101','Sam Paint'), ('c102','Ramon Hardware'), ('c103','Li Auto');--INSERT INTO detail VALUES ('s201','i301',21), ('s201','i302',22), ('s202','i302',23), ('s202','i303',24), ('s203','i303',25), ('s203','i304',26);--INSERT INTO item VALUES ('i301','Doormat',6.00,80),…
Course: Principles of Database please solve it within 30 minutes. please please, pleaseThank you Single Choice Questions 6. In SQL Server, there are two types of databases: system databases and ( ). A. Object-oriented databases. B. User databases. C. Relational databases. D. Test databases. 7. Normalization of the database schema is performed during the ( ) of database design. A. Requirements analysis phase. B. Conceptual design phase. C. Logical design phase. D. Physical design phase. 8. The incorrect operation expression involving NULL values in SQL is ( ) A. AGE IS NULL B. AGE IS NOT NULL C. AGE = NULL D. NOT (AGE IS NULL) 9. One of the characteristics of a database is data sharing, strictly speaking, data sharing refers to ( ). A. Multiple programs sharing a data collection within the same application. B. Multiple users sharing data in the same language. C. Multiple users sharing a data file. D.…
Use Mysql code The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule for Feb 1, 2020 with the lesson date/time, student's first and last names, and the horse's registered name. Order the results in ascending order by lesson date/time, then by the horse's registered name. Make sure unassigned lesson times (student ID is NULL) appear in the results. Hint: Perform a join on the LessonSchedule, Student, and Horse tables, matching the student IDs and horse IDs.
ormulate the following queries in Structured Query Language SQL The following tables form part of a database held in an RDBMS: Employee (empNo, fName, lName, address, DOB, sex, position, salary, deptNo) Department (deptNo, deptName, mgrEmpNo) Project (projNo, projName, deptNo) WorksOn (empNo, projNo, dateWorked, hoursWorked) where Employee contains employee details and empNo is the key. Department contains department details and deptNo is the key. mgrEmpNo identifies the employee who is the manager of the department. There is only one manager foreach department. Project contains details of the projects in each department and the key is projNo (notwo departments can run the same project). WorksOn contains details of the hours worked by employees on each project, and empNo/ projNo/dateWorked form the key. Formulate the following queries in Structured Query Language SQL List all the details of employees who are female and born after 1990. List employee numbers and names of all…
Create a concept map (with arrows) showing the relationship between the following terms: Data type, Null, Data, Primary key, Query, Relational database, Referential integrity, Row, SQL, Table
a) Create the proper database using sql queries that stores students information (ID,Name) with thier marks (Testl, Test2, Assignment1, Assignment2) then calculate and store the total mark and the final grade (A, B, C, D or F) within the same database. b) Add to the created database in (a), 10 records and then delete the record with the lowest total mark after viewing all the record (only ID and final grade).

SEE MORE QUESTIONS

Recommended textbooks for you

Fundamentals of Information Systems

Computer Science

ISBN:

9781337097536

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

MIS

Computer Science

ISBN:

9781337681919

Author:

BIDGOLI

Publisher:

Cengage

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781305971776

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781337097536

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

MIS

Computer Science

ISBN:

9781337681919

Author:

BIDGOLI

Publisher:

Cengage

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781305971776

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS