Need help with #2,#3,#4,#5 Will provide my relational schema representation The following are the transactions you have to implement for this part of the homework:1. Load some initial data (as discussed above) into the database tables that you created in Part 2.1 of theassignment. You can either write a loading program, or use SQL (insert command. Your data shouldbe kept in files so that it can easily be reloaded during debugging. The data format should be designedby you.2. Write queries to retrieve and print all the data you cntered. Try to print the data so that it is easy tounderstand (for example, print appropriate headings, such as: Customers, Compact Cars, SUVS,Current Rentals, etc).3. Write the following database update transactions using PHP or some other programming language orscripting language.3.1 The first transaction is to add information about a new CUSTOMER.3.2 The second transaction is to add all the information about a new CAR.3.3 The third transaction is to add all the information about a new RENTAL reservation (this must finda free car of the appropriate type for the rental period).3.4 The fourth transaction is to handle the return of a rented car. This transaction should print the totalcustomer payment due for the rental, and enter it in the database.3.5 The fifth transaction is to enter or update the rental rates (daily and weekly) for a type of car.4. Each transaction should have a user friendly interface to enter the information needed by thetransaction. This can either be a Web-based interface or a command line interface.5. Test your transactions by adding a few new customers, cars, reservations, by changing some rentalrates and reservations rates. Vehicle_detailsVehiclelDCategoryldcategoryTypeModelYeardailyRate weekelyRateCustomer_detailsIdNoNamePhoneRental_DetailsRentalldRentalTypecurrentORScheduledAmountDueVehiclelDIdNoDaily_rental_detailsRentalldNoofDaysstartdateReturndateWeekely_Rental_detailsRentalldNoofWeeksstartdateReturndate

Answered: Image /qna-images/answer/180b3899-2941-44c4-b26c-6d756d59c22f.jpg

Answered: 3,#4,#5 Will provide my re

Engineering

Computer Science

3,#4,#5 Will provide my re

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

Related questions

Q: In the relational data model, relations (i.e., tables) store data representing only entities of the…

A: Given: In the relational data model, relations (i.e., tables) store data representing only entities…

Q: 2/e added at Given the following table: a) Identify functional dependencies and name the type of…

A: PrCode → PrName, PrMgr ENum → EName, DNum DNum → DName

Q: Is temporally variable information a thing in relational database design? Is that the case, what…

A: Time-variant: The passage of time is connected to the data that is stored in a data warehouse. The…

Q: What challenges arise when trying to model "many-to-many" relationships in relational databases?

A: A relational database is a type of database management system (DBMS) that organizes and stores data…

Q: What is functional dependency in the context of normalization, and how does it relate to database…

A: Functional dependency is a fundamental concept in database normalization that defines the…

Q: How do data modeling techniques vary between traditional relational columns and JSON/XML columns?

A: Given,How do data modeling techniques vary between traditional relational columns and JSON/XML…

Q: Give four reasons to create an instance of your relational schema with sample data?

A: Given: Give four reasons to create an instance of your relational schema with sample data?

Q: Explain the concept of a foreign key constraint in database design. How does it enforce referential…

A: A foreign key is a column or combination of columns within a table that requires its values to…

Q: Implement a new independent entity phone in the Sakila database. Attributes and relationships are…

A: There is only one error in the above code and that is the ALTER TABLE command on the address table.…

Q: magine you are asked to design a simple database for an airport. You should accommodate for: -…

A: Database is a tool to store data in the computer system and the language to communicate with the…

Q: What is normalization in the context of database design? Why is it essential, and what are the…

A: Normalization in the context of database design is a process used to organize a relational database…

Q: Is it ever a good idea to use composite primary keys? What are your thoughts on using composite…

A: Composite primary keys are a special type of primary key.

Q: Why are some table structures deemed terrible while others are deemed good? How can you know which…

A: Given that; The topic is about Why are some table structures deemed terrible while others are deemed…

Q: KimTay Pet Supplies database design (see Figure 2-1) to support the following requirements. A…

A: the solution is an given below :

Q: Discuss the benefits of Second Normal Form (2NF) and Third Normal Form (3NF) in database design.

A: In the field of database design, normalization is a crucial process to organize data efficiently and…

Q: What are the key considerations when designing a hybrid database schema that includes both…

A: In database management systems, a hybrid database schema combines columns with semi-structured or…

Q: considerably simplifies the task of expressing complex queries because they can be written in…

A: Systems or Languages Significantly:"Systems or languages significantly" in the context refers to the…

Q: 1A. Consider the bank database schema as below. loan (loan_number, branch_name, amount) account…

A: Solution is given below :

Question

Need help with #2,#3,#4,#5 Will provide my relational schema representation

The following are the transactions you have to implement for this part of the homework:
1. Load some initial data (as discussed above) into the database tables that you created in Part 2.1 of the
assignment. You can either write a loading program, or use SQL (insert command. Your data should
be kept in files so that it can easily be reloaded during debugging. The data format should be designed
by you.
2. Write queries to retrieve and print all the data you cntered. Try to print the data so that it is easy to
understand (for example, print appropriate headings, such as: Customers, Compact Cars, SUVS,
Current Rentals, etc).
3. Write the following database update transactions using PHP or some other programming language or
scripting language.
3.1 The first transaction is to add information about a new CUSTOMER.
3.2 The second transaction is to add all the information about a new CAR.
3.3 The third transaction is to add all the information about a new RENTAL reservation (this must find
a free car of the appropriate type for the rental period).
3.4 The fourth transaction is to handle the return of a rented car. This transaction should print the total
customer payment due for the rental, and enter it in the database.
3.5 The fifth transaction is to enter or update the rental rates (daily and weekly) for a type of car.
4. Each transaction should have a user friendly interface to enter the information needed by the
transaction. This can either be a Web-based interface or a command line interface.
5. Test your transactions by adding a few new customers, cars, reservations, by changing some rental
rates and reservations rates.

Vehicle_details
VehiclelD
Categoryld
categoryType
Model
Year
dailyRate weekelyRate
Customer_details
IdNo
Name
Phone
Rental_Details
Rentalld
RentalType
currentORScheduled
AmountDue
VehiclelD
IdNo
Daily_rental_details
Rentalld
NoofDays
startdate
Returndate
Weekely_Rental_details
Rentalld
NoofWeeks
startdate
Returndate

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

How do data dictionaries support version control in data modeling and database design processes?
Indicate the changes (using the shorthand representation) that you would need to make to the original KimTay Pet Supplies database design to support the following requirements. There is no relationship between customers and sales reps. When a customer places an order, any sales rep can process the order and create the invoice. On the invoice, you need to identify both the customer placing the order and the sales rep responsible for the invoice. Draw an E-R diagram for the new design.
How does a view maintain data abstraction in a relational database?
Implement a new independent entity phone in the Sakila database. Attributes and relationships are shown in the following diagram: The diagram uses Sakila naming conventions. Follow the Sakila conventions for your table and column names: All lower case Underscore separator between root and suffix Foreign keys have the same name as referenced primary key Write CREATE TABLE and ALTER TABLE statements that: Implement the entity as a new phone table. Implement the has relationships as foreign keys in the Sakila customer, staff, and store tables. Remove the existing phone column from the Sakila address table. Step 2 requires adding a foreign key constraint to an existing table. Ex: ALTER TABLE customer ADD FOREIGN KEY (phone_id) REFERENCES phone(phone_id) ON DELETE SET NULL ON UPDATE CASCADE; Specify data types as follows: phone_id, phone_number, and country_code have data type INT. phone_type has date type VARCHAR(12) and contains strings like 'Home', 'Mobile', and 'Other'. Apply…
Describe the Fourth Normal Form (4NF) and Fifth Normal Form (5NF), also known as Project-Join Normal Form (PJ/NF), and their relevance in advanced database design.
Consider the unnormalized data presented in the STUDENT table below:a) Identify the data redundancies and give reasons why they create problems in schemas. STUNUM STUNAME TUTNUM TUTNAME COURSENUM COURSEDESC GRADE 00118536 John Brown RC985 Rose Carter CS1001 CS1002 CS1003 Comp Research English Database design B A A 00118537 Marie Smith TB526 Tom Black CS9001 CS9002 CS1002 Calculus Javascript English A B C 00118538 Mary Cole PF587 Peter Finch CS9002 CS1003 CS1001 Javascript Database design Comp Research C A A 00118539 Ian Dunkley SH231 Sarah Hardy CS9005 CS9006 CS1002 Information Systems Web Design English A B B 00118540 Bob Marley JH850 Jacqui Hart CS9002 CS1002 CS1003 JavaScript English Database Deign A B C b) Which dependencies represent 1NF violations? Identify and eliminate 1NF violations. Present your table(s) after transformation into 1NF.c) Identify and remove any 2NF violations. Show the resulting schemas and tablesd) Identify and…
What is the purpose of denormalization? Whymight you not want to create one physical tableor file for each relation in a logical data model?
DATABSE
So i have an ER digram( picture below) that needs to Schema Implementation and SQL DDL statements to create database, primary key and foreign keys must be defined