ITS3102 South University-Savannah Creating a Database and Tables

User Generated

EblnyErory

Programming

ITS3102

South UniversitySavannah

Description

  • In Microsoft Access, create the database and tables that you identified in W3 Assignment 2. In Microsoft Word, write the SQL statements to create the database and tables.
  • Write SQL statements to populate the tables. Run the SQL statements in Microsoft Access for populating the tables.

Unformatted Attachment Preview

PERSON TABLE Primary Key Name of Column Full Names (First and Surname) Telephone number E-mail Address Registration Date Password Null (Y or N) N N N Y N Data Type Varchar2(20) Number(10) varchar(255) datetime2(50) varchar(255) Name of Column Room Number Room ID Number Room Phone Number Room Type Room Reservation Date Bed Type Null (Y or N) N N N N N N Data Type Number(10) Number(10) Number(10) Varchar(255) datetime2(50) Varchar(255) Name of Column Reservation ID Check-in Date Check-out Date QR Code Reservation Status Reservation Date Null (Y or N) N N N Y N N Data Type Number(10) datetime2(50) datetime2(50) Number(25) Varchar(255) datetime2(50) Primary Key Name of Column Yes Payment ID Transaction Amount Payment Status Currency Transaction Date Null (Y or N) Data Type N Number(10) N Number(10) N Varchar(255) N Varchar(255) N datetime2(50) Name of Column Card Name Card Type Card Number Expiry Date Card Verification Code Null (Y or N) N N N N N Yes ROOM TABLE Primary Key Yes RESERVATION TABLE Primary Key Yes PAYMENT TABLE CREDIT CARD TABLE Primary Key Yes Data Type Varchar(255) Varchar(255) Number(25) datetime2(50) Number(25) Description Person Name Phone number of the person Email of the person Date of registration Password of the person Foreign Key Foreign Key Table Description Foreign Key Foreign Key Table Number of the room Identification number of the room Contact phone for the room Type of the room Date of reservation Yes Reservation Type of bed in room Description Foreign Key Foreign Key Table Yes Room Description Foreign Key Foreign Key Table ID for the Payment Amount transacted The payment Status Currency of the payment Date of the transaction Yes Description Name of Card Holder Type of Card Number of Card Expiry date of the Card Card Verification code Reservation Foreign Key Foreign Key Table Yes Person Running Head: DATABASE PLANNING 1 DATABASE PLANNING Chernae Dalton 7/30/19 DATABASE PLANNING 2 ER Model for Hotel Booking System • Using Microsoft Visio or Microsoft Paint, create an E-R model of the six tables from your spreadsheet for developing the business requirements and constraints that will maintain the business logic for your database. o The E-R model should be readable and should map to the spreadsheet and the project description. o • It should have all the cardinality and optionality defined. In this case, Microsoft Visio was used to create the ERD model for the tables from the spreadsheet. The Entity Relationship Model has all the cardinality and optionality defined in the project description and the spreadsheet. See the Microsoft Visio output in figure 1 and 2 below: Figure 1 ER Model with Multiplicity DATABASE PLANNING Figure 2 ER Model without Multiplicity 3
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

At...


Anonymous
I use Studypool every time I need help studying, and it never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags