EBK ORACLE 12C: SQL
3rd Edition
ISBN: 9781305465305
Author: CASTEEL
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 1, Problem 3RQ
Explanation of Solution
Entity
- Entity is the basic block for building the data collected about person, place, event, or thing.
- Entities represent attributes that can have multiple instances.
- For example: STUDENT, EMPLOYEE.
Attribute:
- Attribute is a property or characteristics of a DBMS (
Database Management Systems). - It refers to the components of the database. Database tables or database fields are referred to as attributes.
- The instance in a particular row of a database is described by attributes...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Please draw an Entity-Relationship diagram for the given below MOVIE database.
The data requirements are summarized as follows:
Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genres (such as horror, action, drama, and so forth). Each movie has one or more directors and one or more actors appear in it. Each movie also has a plot outline. Finally, each movie has zero or more quotable quotes, each of which is spoken by a particular actor appearing in the movie.
Actors are identified by name and date of birth and appear in one or more movies. Each actor has a role in the movie.
Directors are also identified by name and date of birth and direct one or more movies. It is possible for a director to act in a movie (including one that he or she may also direct).
Production companies are identified by name and each has an address. A production company produces one or more movies.
Task 1: ER diagram for give scenario
Consider building a database for a shopping mall with requirements as follows:
Each product of the shopping mall has a unique project No, and also has a name, a supplier name, a category, a purchase price and a selling price.
Products need to be supplied from suppliers. Each product has one supplier, but a supplier may supply many products for the shopping mall.
Each supplier has a supplier name and address.
A purchase order for product from a supplier has a unique order No, and a date. The order specifies one or more products and their quantities required for a product.
A sales order for product to customers has a unique order No, and a date. The order specifies one or more products and their quantities required for a product
The shopping mall has warehouses. Each warehouse has a warehouse number, an address and a contact phone number. Each warehouse has shelves to store products. Each shelf has a shelf-number and a capacity. The shelf…
Draw ER (or EER) diagram: A conceptual database design for a chain of furniture stores is needed. The following is a summary of the database requirements:
a) The chain has many different stores in various cities and states. Each STORE has unique StoreNumber, plus an Address(made up of Street, City, State, ZipCode), and a StoreManager (who is an employee). Each store is organized into a number of departments.
b) Each DEPARTMENT contains certain types of furniture (such as ‘dining’, ‘living room’, ‘bedroom’, ‘office’, etc.), and has a DeptName that is unique within each store; it also has a DeptManager (who is an employee), and a number of SalesPersons (who are employees).
c) The company employs many employees. Each EMPLOYEE has a unique SSN, plus a Name (made up of FirstName, Minit, LastName), a job (e.g. ‘store manager’, ‘dept manager’, ‘sales associate’, ‘sales person’, etc.), plus DateOfBirth, Sex, Salary, and CommissionRate. Each employee works for a particular store.
Design an ER…
Chapter 1 Solutions
EBK ORACLE 12C: SQL
Ch. 1 - Prob. 1RQCh. 1 - Prob. 2RQCh. 1 - Prob. 3RQCh. 1 - Prob. 4RQCh. 1 - Discuss the problems that can be caused by data...Ch. 1 - Explain the role of a primary key.Ch. 1 - Prob. 7RQCh. 1 - Prob. 8RQCh. 1 - What type of relationship can’t be stored in a...Ch. 1 - Identify at least three reasons an organization...
Ch. 1 - Prob. 1MCCh. 1 - Prob. 2MCCh. 1 - Prob. 3MCCh. 1 - Prob. 4MCCh. 1 - Prob. 5MCCh. 1 - Prob. 6MCCh. 1 - Prob. 7MCCh. 1 - Which of the following has no partial or...Ch. 1 - Prob. 9MCCh. 1 - Which of the following has no partial dependencies...Ch. 1 - Which of the following has no repeating groups but...Ch. 1 - Prob. 12MCCh. 1 - Prob. 13MCCh. 1 - A unique identifier for a data row that consists...Ch. 1 - Which of the following symbols represents an...Ch. 1 - Prob. 16MCCh. 1 - Which of the following represents a field in a...Ch. 1 - Which of the following defines a relationship in...Ch. 1 - When part of the data in a table depends on a...Ch. 1 - Which of the following is used to join data...Ch. 1 - Which tables and fields would you access to...Ch. 1 - Prob. 2HOACh. 1 - Prob. 3HOACh. 1 - Prob. 4HOACh. 1 - Access path A database table is composed of...Ch. 1 - Prob. 6HOACh. 1 - Prob. 7HOACh. 1 - Prob. 8HOACh. 1 - Prob. 9HOACh. 1 - Prob. 10HOA
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
- Using a graphics program, develop an entity-relationship diagram for a database application for an Internet bookstore where students buy textbooks from a salesperson and receive invoices for their purchases. Use Figure 5.5 as a guide.arrow_forwardIn the database, what is the difference between attributes and entity. This can be clarified by a form in which everything is shown. For example, this is an arrow to what it refers to, and this is a circle to what it indicates. Thank youarrow_forwardDraw the ER diagram based on the following specification. A tutorial school is using a database to manage information about teachers, courses, and students. Each teacher is identified by staff_id, has a name, an email address, and a phone number. Each student is identified by student_id, has a name, an email address, and a registration date. Each course is identified by course_id, year, and semester. In addition, each course has a name. Each course is associated with multiple lessons. A lesson has a lesson number, a location, a date, a start-time, and an end-time. Lesson numbers are sequentially numbers, starting from 1, generated separately for each course. Each teacher teaches at least one course. Each student takes at least one course. Each course is taught by one teacher. Each course can be taken by many students.arrow_forward
- Consider the E-R diagram for a university database as shown in Figure 1. Which ones are super keys for course?(a) course id(b) course id, title(c) course id, title, credits(d) course id, creditsarrow_forwardDesign a database for a worldwide package delivery company (e.g., DHL or FedEx). The database must be able to keep track of customers who ship items and customers who receive items; some customers may do both. Each package must be identifiable and trackable, so the database must be able to store the location of the package and its history of locations. Locations include trucks, planes, airports, and warehouses. Your design should include an E-R diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.arrow_forwardDesign a database for an airline. The database must keep track of customers and theirreservations, flights and their status, seat assignments on individual flights, and the scheduleand routing of future flights. Your design should include an E-R diagram, a set of relationalschemas, and a list of constraints, including primary-key and foreign-key constraints.arrow_forward
- Write the proper sequence of activities for the design of a video rental database. (The initial ERD was shown in Figure 9.9.) The design must support all rental activities, customer payment tracking, and employee work schedules, as well as track which employees checked out the videos to the customers. After you finish writing the design activity sequence, complete the ERD to ensure that the database design can be successfully implemented. (Make sure that the design is normalized properly and that it can support the required transactions.)arrow_forwardConsider the E-R diagram for a university database as shown in Figure 1. What is the primary key for section?(a) sec id(b) sec id, semester, year, course id(c) sec id, semester, year(d) sec id, semester, year, course id, time slot idarrow_forwardUsing the Crow’s Foot Diagrram technique, draw a database design for the attached database.arrow_forward
- Database design diagrams (DBDL) and entity-relationship (E-R) diagrams (ER) are both valid ways to depict a database's structure. For what reasons do you choose one tactic over another?arrow_forwardCreate an ER diagram that correctly describes the database for exams at Campus in Bäcksvängen in accordance with the following description: (Own assumptions must be clearly described.) Staff for various functions are involved in the exams. All staff have a full name and a unique staff code. Some people are examiners on one or more courses. A course has one name and one unique ladok code. For a course, you can add up its points based on the associated elements. One part is part of a course (for example an exam, a laboratory or project). A course can have several different parts. An element has a name, a description, a torque code, one point and two or more grades (eg: U, G, VG). An element can only belong to one course. Since the database is to process the exams, it is obvious that a part like described as an examination has an examination opportunity that is identified, among other things, by the date, start time, end time and that it is possible to calculate total writing time. A…arrow_forwardWhat type of relationship in the conceptual model is converted to an entity in the logical database design?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
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