Question

1. write 2- to 3-page document that contains the following items:.Describe one website of an airplane ticket vendor you would recommend for upgrading with the CRUD technique.Identify events, actors and relationships existing in the website.Prepare a CRUD matrix table showing use cases and classes (entities) for the website.
2. What is the main purpose of using the CRUD technique?
3. What CRUD functions are available to a user in the websites?
4. What are the legal issues connected with personal data storage in the websites found and how possibly the CRUD technique might help to deal with them?

Answer 1

I looked through the web and found a plane ticket merchant site that I believe isn't using(or not at a significant level) CRUD technique.So I would prescribe this site to utilize or build the utilization of CRUD method.

www.ezeego1.co.in is a online airplane ticket vendor website which provides the purchasing of airplane tickets.Its an Indian company.

Basic Description -

• ezeego1 is one of a kind in a manner since it is a Travel Meta Search site with booking capacities. It is where the customer gets ongoing data and exchange capacity on the web. All movement suppliers both on the web and disconnected will be spoken to on ezeego1.
• It's quick, easy, time saving and helps in doing comparisons at the backend to give you the best rates available.The portal has strong online and offline fulfillment systems.

​Events and existing relationships -

It also offers Representation Services for Global Brands wanting a presence in the Indian Market. It is also a marketing arm for Suppliers, NTO, Principals and Trade Partners. It boasts of a 24x7 Fulfillment & Customer Service Support.​

Note: There were no actors associated with this website.

Why this website should use CRUD Technique -

CRUD stands for Create, Retrieve, Update and Delete which are four major functions implemented in a database application.The CRUD functions are the user interfaces to databases, as they permit users to create, view, modify and alter data. CRUD works on entities in databases and manipulates these entities.

By applying this technique the UI(User Interface) of the website will be improved which not looks very good currently as well as the overall functionality and efficiency of the website will also be increased.

Furthermore, using CRUD operations helps to prevent SQL injection attacks. By utilizing stored procedures instead of string concatenation to build dynamic queries from user input data for all SQL Statements means that everything placed into a parameter gets quoted.

____________________________________________________________________________________________

CRUD table, I have given the overview of how it will be if implemented.Here is the image -

CRUD Table for Airplane Ticket Vendor Ialebsite : C R D S.No. Create Read Update Detete User Action Enter the Website 1 2. Search the - - Site 3. 4. Data 5. Ticket 6. arden Site Directory Login User User Audit Selecting the Random ID User Info | Flight Flight the Booking Orders, Seat No. Seats, Seat Flight Options Optione, provid Table Cancelling Order Number, Order Number Avilable Seleted Tickets. Loa Sub Lan Amount Seats, Information. Flight Removal seat Payment Payee ID, Ovde Summary, Providers, Method Botel Amount Reserved seats Posting Message Comm_Messages Comon-Messages Comments to the Board Comments, User Info Database 1 Reviews This is just of the Table In Real, would be too large to Create & 7. List, Payment Info. Details, 8 Overview this table write like thes

The purpose of CURD is:

The investigator distinguishes all the information components to be handled by the framework and makes use cases that make, report on, update, and erase the information things.

CRUD functions :
1. Build a MP3 CRUD (create, read, update and delete) application that stores and plays MP3 sound files.
2. Be able to add user authentication using PHP/Mysql.
3. Be able to secure a database.
like many more.

CURD prevent many legal issue associated with data strorage, these are prevent by CURD and some are listed below :

• The Data Access Layer communicates with the Data Storage Layer to perform CRUD operations.
• CRUD procedures prevent the SQL Injection Attacks on data storage.
• URIs are of course a concept that doesn't really line up with CRUD.

I tried a lot to write a perfect answer. Please up vote. Your up vote is so valuable to me. Thank you so much.