A hotel chain stores guest information in a structured database - Edexcel - GCSE Computer Science - Question 2 - 2019 - Paper 1

In a structured database, guest information would typically be organized in a tabular format, where each row represents a unique guest record and each column corresponds to specific attributes or characteristics of that guest. This would include fields such as guest ID, name, contact information, payment details, and reservation history. Relationships can be established through keys, with foreign keys linking guest records to other tables, such as bookings or room details, ensuring a well-organized and efficient data structure.