I want to make a project for DBMS my topic is Bus Station manegmentl want from you to write a1 - uml diagram2 - relational database with referential integrity constraints3 - the SQL Statment CodePlease choise the entity from youLike bus, route, garage, towns, stage,drivers and any needs for project Someone help me pleaseDo it In grave not writing and do all relations 1:1 1:m m:m here is the examples of the schema ACCOUNT Forejary lay Primery Key \table[[ACDOUNT, branchName,balance,a countinumber,], [...], [BRANCH, branchName, address,assets,], [Primary Rey...], [CUSTOMIER, customer Number,name, address,home Branch], [4,,, Furcigntey], [\table [[ACOOUNT], [-HOLDER]], customer Number, account Number,,], [Foreign key,Foregritiey..]]

I want to make a project for DBMS my topic is Bus Station manegmentl want from you to write a1 - uml diagram2 - relational database with referential integrity constraints3 - the SQL Statment CodePlease choise the entity from youLike bus, route, garage, towns, stage,drivers and any needs for project Someone help me pleaseDo it In grave not writing and do all relations 1:1 1:m m:m here is the examples of the schema ACCOUNT Forejary lay Primery Key \table[[ACDOUNT, branchName,balance,a countinumber,], [...], [BRANCH, branchName, address,assets,], [Primary Rey...], [CUSTOMIER, customer Number,name, address,home Branch], [4,,, Furcigntey], [\table [[ACOOUNT], [-HOLDER]], customer Number, account Number,,], [Foreign key,Foregritiey..]]

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 database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined) CUSTOMER (CustID, FirstName, LastName, City, Phone, Email) INVOICE (InvoiceNumber, CustID, Date) INVOICE_ITEM(InvoiceNumber, ItemNumber, Quantity) ITEM (ItemNumber, ItemName, UnitPrice) When a customer makes a purchase, an invoice is created. The invoice may be for many items. For example, in a single purchase, a customer might buy 10 Back Scratchers, 4 Hair Removers and a Dog Lead. Provide relational algebra (NOT SQL) queries to find the following information. NOTE: You can use the symbols s, P, etc., or the words’ PROJECT’, ‘RESTRICT’ etc. as you prefer. You do not need to try to make efficient queries – just correct ones. Where you use a join, always show the join condition. List the dates on which Homer Griffin made purchases. List the first and last names of customers who have bought “Back Scratcher” or “Hair Remover” List the first…
Since the database is not available the following is provided to gain a better understanding Sales Table contains the following fields- Sales ID, Invoice No., TransDate, Description, Colour, Size, Qty, Price , Store ID, Year ID, Brand, Name (of customers), Address, Currency Id, Yearval Location Table contains the following fields - Store ID, Store Name, Store Type (which details what is Duty paid(DP) or Duty free(DF)), Hotel, Home Currency, and Can sell? Currency Table fields are - Currency ID, Rate (rates- USD: 2.0675 and BDS: 1) Relationships between tables have been formed and referencial intergrity enforced. QUESTIONS The company has been informed that the tax has been increased from 15% to 17.5%. Calculate how much additional tax (i.e., the difference) the store would have collected by year. Name this query Q3 – ADDED-TAX. Then, Create a report showing the following for Jan, Feb, Mar in 2009. Duty-free sales, duty-paid sales, and taxes (original) are collected monthly by…
The following tables form part of a database held in a relational DBMS: Hotel (h) hotelNo, hotelName, cityRoom (r) roomNo, hotelNo, type, priceBooking (b) bookingNo, hotelNo, guestNo, dateFrom, dateTo, roomNoGuest (g) guestNo, guestName, guestAddress where the bolded attributes are the primary keys for the respective tables. Using the above tables, answer the following questions: 1. List the names and addresses of all guests in London, alphabetically ordered by name. 2. List all double or family rooms with a price below $40.00 per night, in ascending order of price. 3. What is the total revenue per night from all double rooms?
Practical Tasks for Database Systems Question:1 Show all data from employee table where name should be in ascending and salary in descending order. Question:2 Show the total length of (eno, deptno). joined it and rename by function from the employee table? Question:3 Show the ename first 3 alphabets of manager? Question:4 Write a query that show the manager data like this. ename job ***MANAGER *** MANAGER JONES BLAKE Question:5 Calculate the percentage of any student and round to 0 digit? Question:6 Show the last date of December 2014? Question:7 Show the date of next data base class and rename by cs-400? Question:8 Convert today date to character?
I need crow's foot diagram for my ms sql server hospital database project. I add the business rules and the assets I created below. Business Rules A patient can only visit a doctor.A doctor can examine many patients. An examination can be done by a doctor.A doctor can do multiple exams.A patient can request more than one exam from the doctor. Each staff member can only have one title.Some staff members may not have a title. A hospital can employ more than one doctorA doctor can work in a single hospital. A patient can give more than one test.Each assay can only be given by one patient. A prescription is for one patient only.A patient may have more than one prescription. It can contain many drugs in one prescription.The same medicine can be prescribed in many prescriptions. Only one patient can stay in a ward.More than one patient can stay in each room.A patient can stay in only one room. By the way, Please alert me if you think I have made the relational diagram wrong. I'm so grateful…
The following relations are part of a general store database: customer(custnum, custname, city, creditlimit) orders(ordernum, orderdate, filled, custnum) orderline(ordernum, productnum, quantity, salesprice) product(productnum, descr, producttype, msrp, onhand) Here is a sample data (assume there are more records)Using PROJECT, SELECT and JOIN, write the sequence of operations to answer each of the following questions: 1a. What are the names and customer numbers of customers who are from Mississauga? 1b.What are the names of products (descry) and product types of products purchased by customers from brapton?
Prepare a MySQL script that creates your database, tables, and inserts a small sampling of madeupdata. Test it out in MySQL before submission For the below diagram write the SQL queries
If you sell a house more than once, it is treated as different "property" for each sale. Draw an entity-relationship diagram and write a database design outline. Q2. Law Office: You are trying to automate the records for your uncle's law firm. Multiple attorneys work for the firm, and for each of them you want to store their first name, last name, date hired, hourly billing rate, and date promoted to partner (blank if the attorney is not a partner). Each attorney has multiple cases, which is identified by a unique "docket number". Each case has a name and description, is worked on by only one attorney, and involves a single client. For each client, you want to store a first name, last name, middle name, phone number, address, city, state, and zip code (assume you do not have a zip-code table). Finally, you want to keep track of the billable hours spent on each case. For a single case, this comprises information that looks like Hours Billed Date 2/24/2005 Description Prepare brief…
So i have an ER digram( picture below) that needs to Schema Implementation and SQL DDL statements to create database, primary key and foreign keys must be defined
urgent
Question A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (M170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The class…
The following tables describe the content of a relational database: