You will need to create the database tables and choose sensible data types for each column.Make sure to maintain entity and referential integrity, and implement all the above constraints.Since other developers work in parallel on other parts of the system, you will need to strictly follow the above specification to correctly implemented in your database. Otherwise, the other software will not be able to use your database. This means, one needs to be able to rely on all constraints being correct, the spelling of table and column names being as given, and that the data types that you chose will allow for sensible data to be added to the database in the future.For testing purposes, you are asked to insert the data specified below into the tables, but no other data except this.In short:1. You will need to create the tables as specified2. You will need to add the data specifiedPlease use the 3.sql and implement your tables using the sketched CREATE TABLE commands. Add the necessary queries in the file where indicated.3.sql: -- Task 1: Create Tables and Insert Data-------------------------------------------------------------------------------CREATE TABLE Customer ( );CREATE TABLE Park ( );CREATE TABLE Booking ( );CREATE TABLE ActivityLeader ( );CREATE TABLE Activity ( );CREATE TABLE Admin ( );CREATE TABLE Lodge ( );CREATE TABLE BookingLodge ( );-- Add data to the tables:-- (add your queries here) A booking is for a specific park.A booking can choose one or more lodges as part of the booking.ConstraintsYou also agreed on the following domain constraints:• ArrivalDate in Booking should be no earlier than the current date• DepartureDate in Booking should be no earlier than the ArrivalDate• Special Requests in Booking should permit an arbitrarily long description of the requestDOB in ActivityLeader and Admin should be before the current date• Salary in ActivityLeader and Admin cannot be negative• WorkAdjustment in ActivityLeader and Admin should permit an arbitrarily longdescription• Role in Admin should only allow the values Manager, Receptionist, HR, Sales, MarketingTarget Audience in Activity should only allow the values Children, Adults, Allarea in Lodge should only allow the values Central, Outer, Exclusive•LodgeNo and MaxOccupants in Lodge should only allow values larger than zeroa LodgeNo can only be used once in the same parkTo ensure that all required data is available, you agreed on the following null-ability of attributes:• All Attributes should be NOT NULL, except for:o SpecialRequests in Bookingo WorkAdjustment in ActivityLeader and Admino DBSCheck in ActivityLeader. No foreign key is allowed to be null, because none of the relationships are optional. ScenarioYou were contracted by as software development company as a database expert to help completethe implementation of a database design. After long discussions with the customer, the leaddeveloper provided the following logical data model that needs to be implemented in a PostgreSQLdatabase. The data model also comes with assumptions and constraints that were agreed with thecustomers and need to be implemented exactly.Logical Data ModelCustomerCustomerNo (PK)FirstnameSurnameEmailAddressPhoneNoActivityActivityID (PK)NameOnDateTimeDurationTargetAudienceParkid (FK)StaffiD (FK)••.◄Assumptions.0.Leads 11Makes* SchedulesStaffID (PK)FirstnameSurname0.0...*ActivityLeaderDOBAddressPhoneNoSalary1.1ο EmploysWorkAdjustmentsDBSCheckSpecialityParkID (FK)BookingBookingNo (PK)BookingDateArrivalDateDepartDateSpecial RequestsCustomerNo (FK)ParkID (FK)Has1.11..1ParkParkID (PK)AddressPostcode1..1An activity leader may not lead any classes yet.A park may not have scheduled any activities.11EmploysAdminStaffID (PK)FirstnameSurnameDOBAddressPhoneNoSalaryRoleParkID (FK)SelectsWorkAdjustmentsA park may schedule multiple activities at the same time.A park may not yet have any bookings.Provides1.BookingLodgeLodgelD (PK, FK)BookingNo (PK, FK)NumberGuestsPrice0.Added ToLodgeLodgelD (PK)AreaLodgeNoMaxOccupantsWheelchair AccessibleDogsAllowedParkID (FK)

DBMS stands for Database Management System, which is a software system used for managing and…

ou will need to create the database tables and choose sensible data types for each column. Make sure to maintain entity and referential integrity, and implement all the above constraints. Since other developers work in parallel on other parts of the system, you will need to strictly follow the above specification to correctly implemented in your database. Otherwise, the other software will not be able to use your database. This means, one needs to be able to rely on all constraints being correct, the spelling of table and column names being as given, and that the data types that you chose will allow for sensible data to be added to the database in the future. For testing purposes, you are asked to insert the data specified below into the tables, but no other data except this. In short: 1. You will need to create the tables as specified 2. You will need to add the data specified Please use the 3.sql and implement your tables using the sketched CREATE TABLE commands. Add the necessary queries in the file where indicated. 3.sql: -- Task 1: Create Tables and Insert Data ------------------------------------------------------------------------------- CREATE TABLE Customer ( ); CREATE TABLE Park ( ); CREATE TABLE Booking ( ); CREATE TABLE ActivityLeader ( ); CREATE TABLE Activity ( ); CREATE TABLE Admin ( ); CREATE TABLE Lodge ( ); CREATE TABLE BookingLodge ( ); -- Add data to the tables: -- (add your queries here)

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...