****SQL DATABASE IN ACCESS**** Pitt Fitness database tables: 1. Classes (ClassID, ClassName, Room, Location, LengthofTime, MaxSize, TypeofClass, Day, Time, Description) 2. ClassInstructors (ClassID, InstructorID) 3. Customers (CustomerID, LastName, FirstName, StreetAddress, City, State, ZipCode, EmailAddress, PhoneNumber, BirthDate) 4. Instructors (InstructorID, InstructorLastName, InstructorFirstName, InstructorStreetAddress, InstructorCity, InstructorState, InstructorZipCode, InstructorEmailAddress, InstructorPhoneNumber) 5. Reservations (ReservationID, ClassID, ClassDate, ClassPrice, OtherFees, CustomerID) Assume that the Pitt Fitness accountant has met with the owner to discuss how to handle payments and balances. They both decide to add fields to the Customers table to record any payments arriving and the subsequent balance. Add the appropriate fields to the Customers table and set up a Before data macro to check the payment and balance.

SQL DATABASE IN ACCESS Pitt Fitness database tables: 1. Classes (ClassID, ClassName, Room, Location, LengthofTime, MaxSize, TypeofClass, Day, Time, Description) 2. ClassInstructors (ClassID, InstructorID) 3. Customers (CustomerID, LastName, FirstName, StreetAddress, City, State, ZipCode, EmailAddress, PhoneNumber, BirthDate) 4. Instructors (InstructorID, InstructorLastName, InstructorFirstName, InstructorStreetAddress, InstructorCity, InstructorState, InstructorZipCode, InstructorEmailAddress, InstructorPhoneNumber) 5. Reservations (ReservationID, ClassID, ClassDate, ClassPrice, OtherFees, CustomerID) Assume that the Pitt Fitness accountant has met with the owner to discuss how to handle payments and balances. They both decide to add fields to the Customers table to record any payments arriving and the subsequent balance. Add the appropriate fields to the Customers table and set up a Before data macro to check the payment and balance.

Systems Architecture

7th Edition

ISBN:9781305080195

Author:Stephen D. Burd

Publisher:Stephen D. Burd

Chapter3: Data Representation

Section: Chapter Questions

Problem 3RP

See similar textbooks

Similar questions

Module 01 Introduction to Database Management Currently, the class price and other fees reside in the Registration table. If Pitt Fitness practices dynamic pricing (the management changes the prices as the classes fill up as the airlines do), should they put the class price in the Classes table? Why or why not?Entities:1. Classes (ClassID, ClassName, Room, Location, LengthofTime, MaxSize, TypeofClass, Day, Time, Description)2. ClassInstructors (ClassID, InstructorID)3. Customers (CustomerID, LastName, FirstName, StreetAddress, City, State, ZipCode, EmailAddress, PhoneNumber, BirthDate)4. Instructors (InstructorID, InstructorLastName, InstructorFirstName, InstructorStreetAddress, InstructorCity, InstructorState, InstructorZipCode, InstructorEmailAddress, InstructorPhoneNumber)5. Reservations (ReservationID, ClassID, ClassDate, ClassPrice, OtherFees, CustomerID)
A sales system is built using Java. The database used is MySQL with the DB name 'Sales' and has a database structure which is illustrated with the following Class Diagram: *On attachment From the existing Data Class Diagram, please make one I. Database Create a 'Sales' Database using MySQL. Field ID using Auto Increment Enter data into the Customer and Product Tables as follows: Table Customer Customer_ID Customer_Name Customer_Add Int Char(150) Char(100) 1 EFGH, PT XYZ 2 FGHI, CV LMNO 3 DEFG IJKL 4 EFGH MNOP 5 GHIJ QRST Table Product Product_ID Product_Name Stock Int Char(50) Int 1 FFFF 2 2 GGGG 7 3 HHHH 8 4 IIII 6 5 JJJJ 5 II. GUI Create a Sales Order Form with the following attached mockup: *On attachment *Note due to language differences in the mockup: Tanggal means DateKode means CodeNama means NameTambah Item means Add ItemHapus Item means Delete ItemSimpan…
The problems for this chapter use a database for a simple department store that sells items to customers and wants to keep track of the invoices, the selling price (if an item is on sale), and the sales tax (7%) to be collected on some items. Every customer and invoice are assigned unique numbers. All items have a Universal Product Code (UPC) number and bar-code assigned to each unique item. Food and non-carbonated beverages are not taxed, but clothing, home goods, and most other items are. The structure of the tables is described in the following crows foot ERD:
The problems for this chapter use a database for a simple department store that sells items to customers and wants to keep track of the invoices, the selling price (if an item is on sale), and the sales tax (7%) to be collected on some items. Every customer and invoice are assigned unique numbers. All items have a Universal Product Code (UPC) number and bar-code assigned to each unique item. Food and non-carbonated beverages are not taxed, but clothing, home goods, and most other items are.
8. Matrix algebra is a theoretical way of manipulating a database. 9. The union of tables A and B is a table containing all rows that are in either table A or table B or in both table A and table B. 10. The intersection of two tables A and B is the set of all rows that are in table A but that are not in table B.
Imagine a database of students where the StudentID is the main key, and there are other indexes on Major, Age, MaritalStatus, and HomeZipCode (all secondary keys). Let's assume the institution wanted a list of MIS or computer science majors who were over 25 and married and were from the 45462 postcode code OR computer engineering majors who were single and were from the 45462 zip code. In any case, they wanted the list to come from the 45462 zip code. How can indexes be used to guarantee that individuals will only have access to the info that fulfills this prerequisite?
create a class Person to represent a person and another one to represent the database. A dictionary should be a data member of the database class, with Person objects as search keys for this dictionary. Write a program that tests and demonstrates your database.
Short answers: 1. Assume that there are 12 records in training data and there are three classes: C1, C2, and C3. Write down the number of records in each class so that the Gini index is maximum. C1: C2: C3:
QUESTION 1 Happy Learning (this is a fictional scenario) A private kindergarten, Happy Learning, wants to build a database to manage their operations. You were assigned to create an initial design based on the following customer description of their operations. There are 3 age levels in the kindergarten (turtles, foxes and monkeys). At each level there 3 classes (red, blue and green). For a class we keep a code based on the initial of group color and level (e.g. RT for red turtles, GF for green foxes). Each class has a room number and a phone number (with the format (999) 9999999). Also, each class has a maximum capacity (between 25 and 35). For some classes we will keep brief directions to the class location in the building (less than 160 characters). For a student we will keep the name (first, last, middle each less than 15 characters), any nickname (less than 10 characters), date of birth, address, and the class in which the student is currently enrolled. We will process…
Artificial intelligence subject: Question 3: Create a dataframe having students list as indexes while marks in form of columns. Add a column having total marks of students students = ['std1','std2','std3'], phy = [43,51,72], maths = [33,56,73], bio = [54,51,42]
database fundementals: GIVEN: Participant (PNumber, LastName, FirstName, Address, City, State, PostalCode, PhoneNumber, DOB) SK-->FirstName AK-->PhoneNumber Class(ClassNum, Description, NumOfPerson, Fee) SK-->Description ClassParticipant(PNumber, ClassNum, DataOfClass) FK-->PNumber-->Participant FK-->ClassNum-->Class Expand the database design so it will support the following report: Colonial Adventure Tours needs to send an invoice to each participant, listing the classes in which the participant is enrolled as well as the total fees for the classes. The invoice should include the participant’s full name and address. Answer in both DBDL and E-R diagram
QUESTION 1 SQL: Consider the following database schema for flight reservation database. A flight can be booked by many passengers, and a passenger can book different flights. For each booking, the date of the flight and price are recorded. The database schema is given below Flight (FID:int, Airline:string(unique), DepartingAirport:string, ArrivalAirport:string, Rating: int (1,2,3,4,5) ) Booking (FlightID: int, PassengerCPR: int, Date: date, Time: time, Price: double) Passenger (CPR:int, FirstName: String, LastName: String, Address:String) Write SQL Code to: Create the Flight Table.List the Departing Airport and Arrival Airport for all flights with rating 4 or 5.