Suppose you are involved in developing a database system for the ticket booking database of ABC bus company. The operation of the ticket booking can be described as follows. They have a file of booking that they provide to their clients. Each type of ticket has a unique ticket code, as well as, quantity available and a price. • They have a file of clients. Each client is given a unique client number. This file also contains client telephone, and client name. The client name consists of first name and last name. A client may make zero, one or more bookings at a time, and a booking is always placed by one client only. Information as to booking includes the booking date, and quantity. The system is allowed to booking up to 5 bookings per day, bookings limit which is used to validate customer. A booking may involve one or more than one tickets and a ticket involved in more than one booking. may be Given this information, draw an ER diagram for this ABC bus company. Identify and label the primary key(s) of each entity, relationships and the foreign keys required for creating the relational model.

Suppose you are involved in developing a database system for the ticket booking database of ABC bus company. The operation of the ticket booking can be described as follows. They have a file of booking that they provide to their clients. Each type of ticket has a unique ticket code, as well as, quantity available and a price. • They have a file of clients. Each client is given a unique client number. This file also contains client telephone, and client name. The client name consists of first name and last name. A client may make zero, one or more bookings at a time, and a booking is always placed by one client only. Information as to booking includes the booking date, and quantity. The system is allowed to booking up to 5 bookings per day, bookings limit which is used to validate customer. A booking may involve one or more than one tickets and a ticket involved in more than one booking. may be Given this information, draw an ER diagram for this ABC bus company. Identify and label the primary key(s) of each entity, relationships and the foreign keys required for creating the relational model.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

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.
Suppose we have a database for an university. The requirements are as follows: • Professors have an SSN, a name, an age, a rank, and a research specialty. • Projects have a project number, a sponsor name (e.g., NSF), a starting date, an ending date, and a budget. • Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S. or Ph.D.). • Each project is managed by one professor (known as the project’s principal investigator). • Each project is worked on by one or more professors (known as the project’s co-investigators). • Professors can manage and/or work on multiple projects. • Each project is worked on by one or more graduate students (known as the project’s research assistants). • When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a (potentially different) supervisor for each one. The FDs for the above requirements are given as, • PSSN →…
Using the Crow’s Foot Diagrram technique, draw a database design for the attached database.
Use C# to create Order class as follows: a. Data members: oid, orderDate, promised Date, shipDate, deliveryDate, amount, status. b. Behavioral members: isOnTime() - check if the delvieryDate is ahead of promised Date, timeToDelivery() - get number of days from order to delivery, getLate Fees() - company pays 1% fee to the customer for every day of delay in delivery according to the contract.
Assume a database of Employees of a company have been given as shown below:Employee: < ID, Name, ProjCode, Salary>Projects: <projID, ProjName, Budget> For each project, count the number of employees who are paid less than the average salary of that project. Determine if there is any project with a budget less than the total salary paid to its employees. If yes, find the name of the project and its budget.
Scenario 1: A privately owned company that sells industrial kitchen equipment needs to set-up a database for their employees. The company has vastly expanded over the last couple of years and needs to keep track of its employees’ salaries. The salaries are worked out according to the position of the person in the department that they work in. Each department has certain facilities, for example the director’s department has a smoking balcony, the factory has a water cooler e.t.c. Each position has the same salary, regardless of the department. For example, a manager in the factory has the same salary as the manager of the IT department. Each employee is uniquely identified by their employee’s ID number. The CEO would also like to know how many positions in each department there are, as well as the name of the branch each employee works for. Each branch must have the information of the country it is situated in. Question 1: Draw a complete entity relationship diagram with all…
Computer Science It is needed to design a database system for a pharmacy. The pharmacy contains many different items. Items may be products or medicines. Medicines are classified into different types either bills, injection, capsule or drugs or any combination of them. An item must be supplied by only one supplier. A supplier may supply many type of items. A customer may order many items. The pharmacy has a unique name, address and more than one telephone. The doctor can prescribe one or many medication, injections can not be bought without a doctor prescription. You are requested to draw the EERD diagram for the described system You are required to write down any assumptions made from your side You should add the attributes and cardinality for all the entities You are required to model the EERD into relational model
ASS -3 Consider the person database with info table has been created. Develop a web application with functions such as that. The user can choose from the main interface one of the following operations • Add a new record to the information table, in case there is any problem with data entry, help the user by reducing the re-entry process and highlighting the place of the wrong • Search for a specific record by id or first name (use roadio button) • List and Count the number of the record with the same first name or middle name or both together (use check button) • Delete records based on the last name • After the selected process is completed successfully, the main interface appears again with the option to exit
Use the following instructions below to construct a crows foot erd please Suppose you are given the following requirements for a simple database for the National Football League (NFL): the NFL 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 Home Team and Guest team) and has a date (such as May 11th, 1999) and a score (such as 4 to 2) Instructions: Use the Case Study above to complete the following tasks 1. Identify the objects (entities) and attributes based on the information provided in the case study
Please help me with this question ERD diagram.
Subject: OOAD
Use C# to create Order class as follows: a. Data members: oid, orderDate, promised Date, shipDate, deliveryDate, amount, status. b. Behavioral members: isOnTime() - check if the delvieryDate is ahead of promised Date, timeToDelivery() - get number of days from order to delivery, getLateFees() - company pays 1% fee to the customer for every day of delay in delivery according to the contract.