Write a PHP script task4.php that connects to the database and displays the results of the query in Task 1 in an HTML table.This was taks 1:1. List the names and weightings of all assessments in the course titled “Database systems”. The list should be ordered by the assessment name.answer :SELECT name, weightingFROM Assessment a JOIN Course c ON a.cid = c.cidWHERE title = 'Database systems'ORDER BY name; IntroductionA relational database has been created using MySQL to store details about students' performance.There are four tables in the database: Student, Course, Assessment, and Grade. A student takesone or more courses. A course may be assessed by coursework assessments and exam. The nameand weighting of each assessment component are stored in the Assessment table. Students' markson their assessments are recorded in the Grade table.An Entity-Relationship model of the database is shown below:AssessmentCourse1..11.* aid {PK}cid {PK}has >cid {FK}titlenameweighting1.1records1.*StudentGradesid {PK}1.* sid {PK, FK}aid {PK, FK}mark1.1forenameachieves ►surnamegenderwhere PK and FK refer to primary key and foreign key, respectively.The credentials you will need to access the database are given below:Server Name:dragon.kent.ac.ukDatabase name: co323Username:co323Password:h@v3fun

Design Table:- Create table Course(cid int primary key,title varchar(40));desc Course;insert into…

Write a PHP script task4.php that connects to the database and displays the results of the query in Task 1 in an HTML table. This was taks 1: 1. List the names and weightings of all assessments in the course titled “Database systems”. The list should be ordered by the assessment name. answer : SELECT name, weighting FROM Assessment a JOIN Course c ON a.cid = c.cid WHERE title = 'Database systems' ORDER BY name;

Write a PHP script task4.php that connects to the database and displays the results of the query in Task 1 in an HTML table. This was taks 1: 1. List the names and weightings of all assessments in the course titled “Database systems”. The list should be ordered by the assessment name. answer : SELECT name, weighting FROM Assessment a JOIN Course c ON a.cid = c.cid WHERE title = 'Database systems' ORDER BY name;

Database Systems: Design, Implementation, & Management

11th Edition

ISBN:9781285196145

Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Chapter10: Transaction Management And Concurrency Control

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Draw an EER diagram for AIRLINE relational database. According to model, the following requirements are satisfied:The AIRLINE relational database schema shown in the above figure describes a database for airlineflight information. Each FLIGHT is identified by a Flight_number, and consists of one or moreFLIGHT_LEGs with Leg_numbers 1, 2, 3, and so on. Each FLIGHT_LEG has scheduled arrival anddeparture times, airports, and one or more LEG_INSTANCEs—one for each Date on which the flighttravels. FAREs are kept for each FLIGHT. For each FLIGHT_LEG instance, SEAT_RESERVATIONs are kept,as are the AIRPLANE used on the leg and the actual arrival and departure times and airports. AnAIRPLANE is identified by an Airplane_id and is of a particular AIRPLANE_TYPE. CAN_LAND relatesAIRPLANE_TYPEs to the AIRPORTs at which they can land. An AIRPORT is identified by an Airport_code.
The objective is to create a system that allows you to completely manage the functions of thecompany through an optimal design of the data model, to be adapted to a system connected to aSQL database. StatementThe pharmacy chain “Recetas Rayos X” needs a system to manage information about its operations, such as the purchase, sale and administration of medications, other patients and who prescribed them.a medicine. The information that must be stored is the following:1. Patients are identified by the RUT and the name, surname, date of birth, email,address, several telephone numbers and pension system.2. There are various health provisions, both social and private, and they are correctly codified.3. Doctors are identified by the RUT. For each doctor you have to store the first name, last name,date of birth, specialties and years of practice.4. There are various specialties which are adequately codified.5. Each pharmaceutical company is identified by a code, the name and a telephone…
The objective is to create a system that allows you to completely manage the functions of thecompany through an optimal design of the data model, to be adapted to a system connected to aSQL database. StatementThe pharmacy chain “Recetas Rayos X” needs a system to manage information about its operations, such as the purchase, sale and administration of medications, other patients and who prescribed them.a medicine. The information that must be stored is the following:1. Patients are identified by the RUT and the name, surname, date of birth, email,address, several telephone numbers and pension system.2. There are various health provisions, both social and private, and they are correctly codified.3. Doctors are identified by the RUT. For each doctor you have to store the first name, last name,date of birth, specialties and years of practice.4. There are various specialties which are adequately codified.5. Each pharmaceutical company is identified by a code, the name and a telephone…
Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: An international school of technology has hired you to create a database management system to assist in scheduling classes. After several interviews with the president, you have come up with the following list of entities, attributes, and initial business rules: • Room is identified by Building ID and Room No and also has a Capacity. A room can be either a lab or a classroom. If it is a classroom, it has an additional attribute called Board Type. • Media is identified by MType ID and has attributes of Media Type and Type Description. Note: Here we are tracking type of media (such as a VCR, projector, etc.), not the individual piece of equipment. Tracking of equipment is outside the scope of this project. • Computer is identified by CType ID and has attributes Computer Type, Type Description,…
Consider a database schema with a relation Emp whose attributes are as shown below, with types specified for multivalued attributes. Emp = (ename, ChildrenSet multiset(Children), SkillSet multiset(Skills))Children = (name, birthday)Skills = (type, ExamSet setof(Exams))Exams = (year, city) Redesign the database above into first normal form and fourth normal form. List any functional and multivalued dependencies that you assume. Also list all referential-integrity constraints that should be present in the first and fourth normal form schemas.
This test concerns database design, including both the logical design via the Entity Relationship (E - R) model and the physical model via relational database tables. The subject of the model is the registration of students in college classes, and there may be multiple classes for each course. The college model should include: courses (for example the CBU catalog), the current classes (or course-sections) given for courses (for example the CBU schedule for a term), the faculty qualified to teach courses, the scheduling of classes (to buildings/rooms, times, and faculty members), the assignment of faculty to students for advising (1 advisor per student), and the scheduling of students to classes.For unique identifiers you can use the following abbreviations:SID Student IDCID Course ID (ie MIS 471, …)SEC Course Section (ie A, B, C, …)BID Building ID (ie BU, BH, K, …)RID Room NumberFID Faculty IDTID Timeslot ID (ie TR 9:30, MWF 8am, …)CRN Course Record Number (an auto key for each…
3- Consider a database for a university system that needs to store information about students,courses, and instructors. Each student can enroll in multiple courses, and each course can havemultiple instructors. Normalize the following schema to Third Normal Form (3NF), and showyour steps in between (1NF, 2NF).Students (StudentID, FirstName, LastName, CourseID, InstructorID)Courses (CourseID, CourseName, InstructorID)Instructors (InstructorID, FirstName, LastName)4- To keep track of office furniture, computers, printers, and other office equipment, the FOUNDITCompany uses the table structure shown below.a. Given that information, write the relational schema and draw the dependency diagram.Make sure that you label the transitive and/or partial dependencies.b. Write the relational schema and create a set of dependency diagrams that meet 3NFrequirements. Rename attributes to meet the naming conventions, and create newentities and attributes as necessary.
Consider a relational database for an online hotel booking company. The database consisting ofthe following tables (where the primary keys are underlined): Hotel (hId, hName, hAddress, hCity) Guest(gId, gName, gAddress, gCity) Room(hid, roomNo, type, price) Booking(gId, hId, roomNo, fromDate, year, noOfDays)Where hId and gId are identifiers for the hotels and the guests,and the Booking relation indicated that a guest booked a hotel room for a specified number of days(noOfDays) starting from fromDate of a given year. For instance, a tuple < g12345, h5555, 220,Jan05, 2016, 15> in Booking indicates that the guest g12345 booked room 220 of the h5555 hotelfor 8 days starting on Jan 5, 2016. The attribute "gAddress" records the home address of theguests.Write the following queries in relational algebra (1) Return thename of guests who have booked a hotel room in NYC in January 2016 (i.e.,fromDate between 01/01 and 01/31 and year=2016).(2) Return thename of guests who have booked a…
Consider the following Scenario.Design a database for an airline. The database must keep track of customers andtheir reservations, flights and their status, seat assignments on individual flights,and the schedule and routing of future flights. Your design should include an E-Rdiagram, a set of relational schemas, and a list of constraints, including primary-keyand foreign-key constraints.Please determine the entities, attributes and relationships that should exist in thedatabase and draw an E-R diagram.
Design an Entity-Relationship diagram for the below environment. determine 1-Total participation.2-Partial participation Consider a MAIL_ORDER database in which employees take orders for parts from customers. The data requirements are summarized as follows: o The mail order company has employees, each identified by a unique employee number, first and last name, and Zip Code. o Each customer of the company is identified by a unique customer num, first and last name, and Zip Code. o Each part is identified by a unique part number, a part name, price, and quantity. o Each order placed by a customer is taken by an employee and is given a unique order number. Each order contains specified quantities of one or more parts. Each order has a date of receipt as well as an expected ship date. The actual ship date is also recorded.
Q. 1 Consider a university database for the scheduling of classrooms for final exams. This database could be modeled as the single entity set exam, with attributes course-name, section-number, room-number, and time. Alternatively, one or more additional entity sets could be defined, along with relationship sets to replace some of the attributes of the exam entity set, as1. course with attributes name, department, and c-number2. section with attributes s-number and enrollment, and dependent as a weak entity set on course3. room with attributes r-number, capacity, and buildingShow an E-R diagram illustrating the use of all three additional entity sets Listed and also specify the primary keys all
Draw an ER diagram and then map it into a relational schema(database) for the following scenario.• For each MEMBER we keep track of the unique MemdID, a well as Name, Zip, and the Datethe membership was paid.• For each MEMBERSHIP type we keep track of the unique Mid, as well as MName and Price• For each PASS CATEGORY we keep track of the unique PassCatID, as well as PCName andPrice• For each ONE DAY PASS we keep track of the unique PassID and Date• For each MERCHANDISE item we keep track of the unique MrchID, as well as Name andPrice• For each sale TRANSACTION we keep track of the unique Tid and Date• Each member pays for exactly one membership type; each membership type has at leastone member but can have many members.• Each member can buy many day passes but does not have to buy any, each day pass wasbought by exactly one member• Each day pass belongs to exactly one pass category; a pass category can have manyindividual day passes issued for it but does not have to have any. • Each…

SEE MORE QUESTIONS

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning