We would like to design a database to maintain information about COURSES in a Faculty. Each COURSE has a code, name,number of credit hours, and the department that offers it. A COURSE may have zero, one, or many prerequisite COURSES. A COURSE may be a prerequisite .for zero, one, or many COURSES * ?"What is the degree of the relationship type"prerequisite of

We would like to design a database to maintain information about COURSES in a Faculty. Each COURSE has a code, name,number of credit hours, and the department that offers it. A COURSE may have zero, one, or many prerequisite COURSES. A COURSE may be a prerequisite .for zero, one, or many COURSES * ?"What is the degree of the relationship type"prerequisite of

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 11RQ

See similar textbooks

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 identiﬁed 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 identiﬁed 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…
Question: A project is proposed to design a database to store details of laptops in a school. The shop has several laptops, where each laptop can be used by many users. Information to be stored about each laptop includes ID, users, type, and a list of software. Each chapter has exactly one main user and zero or more secondary users. A software has a unique name and validity. Each user has a name and a unique ID and it should be possible to search the database by users names, laptop IDs, and software keywords. Whenever any user uses a software on laptop, the date and time of usage should be recorded; this is used name and role (student, teacher, or administrator). r reporting when a software was last used, as well as recording the number of times a software was used. Each user is identified by a unique ID, has a
1. You want to design a database for a restaurant. Customers have em password. Each customer can have several credit cards registered in the system, each credit card has a 16 digit number, an expiration date, a 3 digit number (CVC code), and the name on the card. The menu items have a short description, a long descriptioin and a price. Customers can place orders that have the date/time that they were placed, one or several menu items (for each menu item it also keeps the quantity), and the total price (summation of the prices of the items mutiplied by the quatity of each item). There are two types of orders: dine-in, or pick-up. In the case of pick-up orders the system must have the car make, model, and color of the person picking up the order, as well as a parking spot number. Dine-in orders have a tip. In addition, the system needs to know if an order has been paid or not. Draw a complete ER diagram. Your diagram must include ISA relationships. If you need to make additional…
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 identiﬁed 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 identiﬁed 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…
A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (CIT 170 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, CIT 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 number…
Store the following fields for a library database: AuthorCode, AuthorName, BookTitle, BorrowerAddress, BorrowerName, BorrowerCardNumber, CopiesOfBook, ISBN (International Standard Book Number), LoanDate, PublisherCode, PublisherName, and PublisherAddress. A one-to-many relationship exists between publishers and books. Many-to-many relationships exist between authors and books and between borrowers and books.a. Name the entities for the library database b. Without creating a set of dependency diagrams, write the relational schema that meet 3rd NF requirements. c. Draw the Crow’s Food entity-relationship diagram for the library database.
A database at a college must support the following requirements: For a department, store its number and name. For an advisor, store his or her number, last name, first name, and department number to which the advisor is assigned. For a course, store its code and description (for example, MTH110, Algebra). For a student, store his or her number, first name, and last name. For each course, the student takes, store the course code, course description, and grade earned. Also, store the number and name of the student’s advisor. Assume that an advisor might advise any number of students but that each of the students has just one advisor. Design the databases for the preceding set of requirements. Use your own experience as a student to determine any functional dependencies. List the tables, columns, and relationships. Also, represent your design with an E-R diagram.
Suppose you are asked to design a club database system based on the following information. Each student has a unique student id, a name, and an email; each club has a unique club id, a name, a contact telephone number, and has exactly one student as its president. Each student can serve as a president in at most one of the clubs, although he/she can be the members of several clubs. Clubs organize activities and students can participate in any of them. Each activity is described by a unique activity id, a place, a date, a time and those clubs that organize it. If an activity is organized by more than one club, different clubs might contribute different activity fees.QuestionDraw an E-R diagram for the system according to the above description.
PART C QUESTION 1 The NAN Book Rental Shop is seeking to implement a database system for its shop. The shop has customers known as members, and a collection of books available for rental. The purpose of the system is to track membership, book inventory, and book rental activities. The following are the current system descriptions associated with NAN Book Rental Shop. For each member, the data items that need to be recorded are: a unique membership identification number, the members' name, address, phone number and the date that the members joined the shop. • When a member rents a book, the shop will record these items: the book rental date, the book return due date, the date the book was returned, and the rental fee. Each member can rent a maximum of five books at any one time and the members must return the books in two weeks time. For each book, the book's identification number, title, type and rental price must be collected and stored in the system. Sometimes books are written by…
Draw an E-R diagram for the description below. Suppose that you are asked to model a database including all pharmaceutical companies, their drugs, and all pharmacies. Each pharmaceutical company is identified by its name and has a phone number. For each drug, the trade name (e.g., Acetaminophen) and formula must be recorded. Each drug is sold by only one pharmaceutical company, and the trade name identifies a drug uniquely from among the products of that company. If a pharmaceutical company stops production, we do not need to keep track of its products any longer. Each pharmacy has an identifier name, address, and phone number. Each pharmacy sells several drugs. A drug could be sold at several pharmacies, and the price could vary from one pharmacy to another.
ERD Model Projects, Inc., is an engineering firm with approximately 500 employees. A database is required to keep track of all employees, their skills, projects assigned, and departments worked in. Every employee has a unique number assigned by the firm and is required to store his or her name and date of birth. If an employee is currently married to another employee of Projects, Inc., the date of marriage and who is married to whom must be stored; however, no record of marriage is required if an employee’s spouse is not also an employee. Each employee is also given a job title (e.g., engineer, secretary, and so on). An employee does only one type of job at any given time, and we only need to retain information for an employee’s current job.There are 11 different departments, each with a unique name. An employee can report to only 1 department. Each department has a phone number.To procure various kinds of equipment, each department deals with many vendors. A vendor typically supplies…
Create ERD for Real-estate database: There are Many Cities in each State There are Many Zip Codes in each City Many Houses belong to each ZipCode Each House can be one of HouseTypes ( Town House, Residential, Condo, Single Family) Each House can be Sold multiple times. ( entity Sales