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)

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)

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

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)

Organized collection of structured information, or data, typically stored in a computer system.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

use c++ to answer the folloing two question 1. implement a city database using a BST to store the database records. Each database record contains the name of the city (a string of arbitrary length) and thecoordinates of the city expressed as integer x- and y-coordinates. The BST should be organized by city name. Your database should allow records to be inserted, deletedby name or coordinate, and searched by name or coordinate. Another operation that should be supported is to print all records within a given distance of a specifiedpoint. Use following two classes:struct city{/* add the city attributes and pointers to left and right child nodes*/}class CityDB{/* create a BST for a City Database here in this class */}Note: The distance formulais > \«: «-w »* , where x1y1 are coordinates of city 1 and x2, y2 are coordinates of city 2. 2.Create the same City Database that you created in the first question using Hash table. Add another attribute in the City record, that is, city_id. Use…
Computer Science A programmer has the task of maintaining a database of students of a large university. There are two types of students, undergraduates and graduate students. All of the students have the same personal information stored, line name, address and courses taken. Each student's GPA is computed, but differently for undergraduates and graduates. The undergraduate have their declared program. The doctoral candidates have information about their dissertations and faculty advisors. Model an inheritance class hierarchy for this database. you are to consider what the common data is and what the unique data would be for each. Work with the details provided above. Just create the class definitions with the constructors and instance variables.
Figure 1 below illustrates an Employee class within an object-oriented database. In the context of this example, explain the following terms: (i) Class. (ii) Object. (iii) Encapsulation. (iv) Inheritance
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…
module 10 An unusual problem has occurred for a small multinational company: People are getting confused about dates in internal memos, purchase orders, and email. When the company’s database was originally designed, the designer was not aware that the format for dates in Canada and Mexico was different from the format used in the United States. For example, in Canada and Mexico, the notation 7/1/19 indicates January 7, 2019, whereas in the United States the same notation indicates July 1, 2019. Although it seems like a small point, the date confusion has resulted in several order cancellations. How would you fix this issue in the database?
Computer Science Design an OO schema for a database application that you are interested in.Construct an EER schema for the application, and then create the corresponding classes in ODL. Specify a number of methods for each class, andthen specify queries in OQL for your database application.
ER Modeling Suppose you are given the following requirements for a simple database for the National Hockey League (NHL): The NHL has many teams Each team has a name, a city, a coach, a captain, and a set of players Each player belongs to only one team Each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records A team captain is also a player A game is played between two teams (referred to as host_team and guest_team) and has a date (such as May 11th, 1999) and a score (such as 4 to 2). Draw the ER diagram to represent the above scenario
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.
G: Race conditions can be occurred in any computer program. Consider a group of two students develop a FYP project and maintain a database in it. One student calls an update( ) function on some data and at the same time second student calls update( ) on the same data to update the database. Describe what problem can be arise in the scenario and what might be done to prevent such problem?
Scripts and stored procedures are two distinct types of objects. In what manners do they exhibit differences from each other? Each of them engages in different activities. Is it more advantageous to utilize a database for the installation of Stored Procedures as opposed to employing an alternative method?
Store the following fields for a library database: AuthorCode, AuthorName, BookTitle, BorrowerAddress, BorrowerName, BorrowerCardNumber, CopiesOfBook, ISBN (International Standard Book Number), LoanDate, PublisherCode, PublisherName, and PublisherAddress. A one-to-many relationship exists between publishers and books. Many-to-many relationships exist between authors and books and between borrowers and books.a. Name the entities for the library database b. Without creating a set of dependency diagrams, write the relational schema that meet 3rd NF requirements. c. Draw the Crow’s Food entity-relationship diagram for the library database.
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…