Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Related questions
Question
Question 1) We plan to construct a
Each parking-lot has id, name, and location. A parking-lot consists of many parking spaces (or spots) and each parking space (or spots) has a unique number.
Every student has School_ID and name. A student can purchase more than one parking-permit.
A vehicle has id, brand, and color. A student can own multiple vehicle.
Each parking permit has no. and price. A parking-permit allows a vehicle to park in dedicated parking spaces (or spots).
The FAU maintains a time table and uses it to record when a student parks a vehicle at a dedicated parking space (or spot) at a specific time-slot in the time- table.
A time-table has id, date, and hour.
Draw an ER diagram for this application. Specify key attributes of each entity type and structural constraints on each relationship type. Note any unspecified requirements, and make appropriate assumptions to make the specification complete.
Question 2) Write DDL statements to create the tables for the ER diagram of Question1.
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
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
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
- A small Hotel owner wish to computerized the management of hotel operations. You are asked to assist in the development of a database for the hotel. The database keeps data about ROOM, EMPLOYEE and FACILITY. From the discussion session with the hotel manager, you have identified the following information: • Three types of ROOMS offered by the hotel are single, double and deluxe room. Each room is identified by its unique number. • In general, there are two main types of the hotel jobs, GUEST SERVICES and ADMINISTRATIVE & SUPPORT. • HOTEL MANAGER, EVENT PLANNER and ACCOUNTANT are the administrative and support job positions in the hotel. • Types of employee falls under the guest services are RECEPTIONIST, HOUSEKEEPER, or KITCHEN STAFF. • Each RECEPTIONIST is identified with her/his name, employee number and years of experience. • The receptionists need to assign a HOUSEKEEPER to each room every morning or whenever it required before the room can be assigned to a guest to ensure the…arrow_forwardWe want to maintain a database for a Faculty within a multi-campus regional university. The facultyhas a number of schools and each school is characterized by its school-code which is unique, nameand campus location. Schools employ professors who are characterized by their unique staff-id, nameand the school they work for. A school offers courses that are characterized by their course-code whichis unique, course name and the school. There are subjects offered within the faculty and these arecharacterized by unique subject-code, title and the school that offers them. Students enroll intocourses that are characterized by student-id which is unique, name, address and phone. The following business rules apply• A course must belong to only one school, but a school may have many courses• A student must be enrolled in a course, but a course may have 0 or more students• A course must have one or more subjects, but a subject may be taught as part of many courses• A student may be enrolled in…arrow_forwardStayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the shorthand representation and a diagram of your choice. For each student renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and e-mail address. For each property, list the office number, property address, city, state, postal code, square footage, number of bedrooms, number of floors, maximum number of persons that can sleep in the unit, and the base weekly rate. For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, end date of the rental, and the weekly rental amount. The rental period is one or more weeks.arrow_forward
- PLZ help with the following: A nonprofit Canadian organization that provides aid to people after natural disasters needs your help to manage their data and to design a database for them using the following business rules: Individuals volunteer their time to carry out the tasks of the organization. Each volunteer may be assigned to several tasks during the time that they are doing volunteer work, and some tasks require many volunteers. It is possible for a volunteer to be in the system without having been assigned a task yet. It is possible to have tasks that no one has been assigned. When a volunteer is assigned to a task, the system should track the start time and end time of that assignment. The tasks of type “packing” result in the creation of packages. Each individual package of supplies that is produced by the organization is tracked. Each package is assigned an ID number. The date the package was created, and total weight of the package is recorded. A given package is associated…arrow_forwardThe following three tables make up a simple reservation system for a small campground. The database should allow for a camper to make multiple reservations for future dates and for a camping spot to have several reservations for upcoming visits. Table: Camper CAMPER_NUMBER 1000 1001 1002 1003 CAMPER_LAST_NAME Jones Schmidt Williams Cooper CAMPER_FIRST_NAME Jamie Pat Clifford Amanda CAMPER_ADDRESS 1278 Essex Pl 4954 Spangled Way 956 Segull Lane P. O. Box 998877 CAMPER_CITY Birmingham El Paso Portland Portsmouth CAMPER_STATE AL TX ME OH CAMPER_ZIP_CODE 45251 79919 4108 45662 CAMPER_DRIVERS_LICENSE JJ998743-98 87632434 WIL885123 765A876B897 CAMPER_EMAIL jjones@somewhere.com patwonderfu34l@nowhere.net williams98342@foomail.com coopera@nowhere.net Table: Spot SPOT_NUMBER 101 102 103 104 SPOT_NAME The Pines The Glade Teardrop Spot Tent In Trees…arrow_forwardIn anticipation of a change to the database, you are asked to provide a list of all products that have 'Man-Made' or 'Man Made' in the the composition text. (HInt: It is easiest to use LIKE in this instance.) In addition, you are requested to replace either 'Man-Made' or 'Man Made' with the word 'Synthetic'. Only include ProductIDs between 1050 and 1060. Show the following in your answer: ProductID, ProductName, Composition, and the modified composition field as 'NewComposition'. (HINT: This problem is a little tricky because you need to replace both 'Man-Made' and 'Man Made'. The way to do this is to use a replace within a replace.)arrow_forward
- The Plaza is an apartment rental company that would like to create an online management system to keep track of apartment complex units, tenants, maintenance requests, and rental payment information. Since you are taking a database class, you are asked to assist the company in designing a database based on the following specifications. Each apartment unit has a unique number.Each unit's street number,street name, city, state zip code, number of bedrooms, monthly rent, and occupancy status are recorded. Each tenant must lease at least one apartment unit for a period of time. It is important to document the lease start date and end date. The Plaza tracks each tenant's name, SSN, home mailing address, and phone number. Each tenant is assigned a unique identifier number. Each tenant should pay the monthly rental fee by the first day of each month.Any rent due not paid by the 4th day of the monthly rental period is subject to a $50.00 late fee charge with an additional $10.00 for…arrow_forwardSuppose you are given the following requirements for a simple database for the National Hockey League (NHL): • There exists many teams in the NHL • Each team has a teamID, name, a city, a coach, and one or more players • Each player belongs to only one team • Each player has a playerID, name, a position (such as left wing or goalie), a skill level, and a set of zero or more injury records . An injury record has an injuryRecordID, a game, a player, and a description. • A game is played between two teams and has a gameID, a homeTeamID, an away TeamID, a date (such asMay 11th, 2017), a home team score, and an away team score. Construct a schema for this database and ensure all relationships cardinalities (1:1, 1:M, M:M) match the requirements above. Then, using this schema, write your Data Definition Language queries in SQL to be able to create these tables in SQLite. Ensure all relevant constraints (Primary Keys, Foreign Keys, NOT NULL, data types) are included. Submit both the schema…arrow_forwardQuestion 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…arrow_forward
- We would like to develop a database that captures the following requirements. A University student can enrol in a course and at least in one major. In fact, a student can enrol in many majors within that course. During the semesters, a student can enrol in units. We want to capture in which year and in which semester a student enrolled in each unit. We have two semesters: Semester 1 and Semester 2. A unit has a code, a title and the number of credit points. We would like also to record the student’s GPA. A course has a code and a name. A major has a code and a name. Also, a major belongs to a course. A unit can be part of either a course or a major. A unit can also be shared across different courses and different majors. Important to note: Provide your design in a textual form, i.e. Entity(Attribute1, Attribute2, Attribute3, …). Make sure that the primary keys of each entity are underlined (Attribute1 in the example above) and foreign keys are indictated in bold (Attribute3 in…arrow_forwardA local businesswoman has decided to start her own Internet business, called Masterpieces Ltd, hiring paintings to private individuals and commercial companies. Because of your reputation as a database designer she has called upon your services to design and implement a database to support her new business. At the initial planning meeting, to discuss the design, the following user requirements were requested. The system must be able to manage the details of customers, paintings and those paintings currently on hire to customers. Customers are categorized as B (bronze), S (silver), G (gold) or P (platinum). These categories entitle a customer to a discount of 0%, 5%, 10% or 15% respectively. Customers often request paintings by a particular artist or theme (eg animal, landscape, seascape, naval, still‐life, etc). Over time a customer may hire the same painting more than once. Each painting is allocated a customer monthly rental price defined by the owner. The owner of the painting is…arrow_forwardCreate a Crow’s Foot notation ERD to support the following business operations: A friend of yours has opened Professional Electronics and Repairs (PEAR) to repair smartphones, laptops, tablets, and MP3 players. She wants you to create a database to help her run her business. When a customer brings a device to PEAR for repair, data must be recorded about the customer, the device, and the repair. The customer’s name, address, and a contact phone number must be recorded (if the customer has used the shop before, the information already in the system for the customer is verified as being current). For the device to be repaired, the type of device, model, and serial number are recorded (or verified if the device is already in the system). Only customers who have brought devices into PEAR for repair will be included in this system. Since a customer might sell an older device to someone else who then brings the device to PEAR for repair, it is possible for a device to be brought in for…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON 
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education