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

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

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

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.
Design the database in an MS Excel spreadsheet as a single relation called Movie. It should contain an ID, Title, Year Released, Genre (e.g., sci-fi, comedy, thriller, etc.), Rating (e.g., G, PG, R, etc.), Format (e.g., VHS, DVD, MP3, etc.), a free-form Comments field, plus the main cast and crew members. Add the following entry plus at least two of your own: Title: Star Trek Year: 2009 Genre: Sci-Fi Rating: PG Format: DVD Director: J. J. Abrams Starring: Chris Pine (Capt. Kirk), Zachary Quinto (Mr. Spock) Zoe Saldana (Uhura), Karl Urban (Bones McCoy) What normal form is this design? Why? What should be done to correct the design?
Open your text editor and create a new document named model.php model.php will contain functions that will connect to a database potentially return PDO statementobjects to the controller for processing. updateMessagesfunction updateMessages($id)This method will take a single parameter of id which is the saved id from the last or latest message displayed. It will conditionally select from the table “messages”, id, name, message, and time. The condition is that the field id is greater than the parameter for id. The return is the PDOStatement object with the row data from the query.
Open your text editor and create a new document named model.php model.php will connect to a database potentially return PDO statement objects to the controller for processing. This question is complete and requires use of initMessagesfunction initMessages($tim) This method will take a single parameter of unix time using the method “time()”. It will conditionally select fromthe table “messages” the minimum id and rename it to “min_id”. The condition is that the field time is greater thanthe parameter for time. The return is the PDOStatement object with the row data from a query.
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.
@model IEnumerable<AdventureDB.Models.Training_Program>@using AdventureDB.Models@{// Create an instance of the data contextvar dbIEFW = new IEFWResourceDataContext();var dbIFE = new IFEResourcesDataContext();var dbREF = new REFDataContext();var dbAQC = new AQCDataContext();var dbAQCUSAF = new AQCUSAFDataContext();var dbIPC = new IPCDataContext();var dbIFTR = new IFTRDataContext();var dbREFUSAF = new REFUSAFDataContext();var dbIPCUSAF = new IPCUSAFResourcesDataContext(); int cntr = 0;ViewBag.Title = "Index";} <h2>Index</h2><div id="calendar"></div><p>@Html.ActionLink("Create New", "Create")</p><div class="body" style="background-image: url('/Images/bckgrnd.JPG'); background-size: cover; background-position: center; background-repeat: no-repeat;"><table class="table"><tr><th colspan="5">@Html.TextBox("startDate", null, new { id = "startDatePicker", type = "date" })<button id="generateCalendarButton">Generate…
1.1 tblMembers The tblMembers will be used to store the details of the Gym Members MemberID, Name, Surname, DateOfBirth, ID,Contact, DateJoined MemberType (Annual: R200/year, Monthly: R50/month)1.2 The tblPayments table will be used to keep track of payments made by Members. PaymentID, Date, Amount. The tblPayments should be related to tblMembers accordinglyUsing Java and the jdbc API , create a startup frame that will be used navigate the application. The frame should have 3 buttons.1.3 The first button will open aa frame that can be used to add, update and delete Gyjm Members. 1.4 The second button will open a frame that will be used to collect the payments made by students.1.5 The third button will display a frame that calculates the current age and the balances, and displays a summary report in a table, as follows for an example:Order # is the sequence number of the member in tblMembers table. Should a member be deleted the system should adjust the sequence as well.- Age is the…
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)
Imagine a browser-based training system that helps students prepare for a certification exam. Astudent can request a quiz from the system. The system picks a set of questions from its databaseand composes them together to make a quiz. It rates the student’s answers and gives hints if thestudent requests it. Tutors also use the system by providing questions and hints and examinerswho certify questions to make sure they are not too trivial.a) Draw a use case diagram from the description above
Write a PHP application that creates a class that allows connection to a specific MySQL database, allowing the specification (by setting some properties) of the location server, user, password, and database name. Give a example of instantiating it (creating an object) and using it in an application with a MySQL table
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…
By given the following models and database context classes, answer the following questions or complete the missing codes: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.ComponentModel.DataAnnotations.Schema; using System.ComponentModel.DataAnnotations; namespace UniversityAssociationMvc.Models { public class Student { public int StudentID { get; set; } public string LastName { get; set; } public string FirstName { get; set; } public string Phone { get; set; } public string Email { get; set; } public DateTime RegistrationDate { get; set; } public virtual ICollection<Membership> Memberships { get; set; } } } using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.ComponentModel.DataAnnotations; namespace UniversityAssociationMvc.Models { public class Club { public int ClubID { get; set;…