Concept explainers
A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each type of account:
CHECKING: Acct No, Date Opened, Balance, Service Charge
SAVINGS: Acct No, Date Opened, Balance, Interest Rate
LOAN: Acct No, Date Opened, Balance, Interest Rate, Payment
Assume that each bank account must be a member of exactly one of these subtypes. using generalization, develop an EER model segment to represent this situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor. Remember to include a subtype discriminator.
Want to see the full answer?
Check out a sample textbook solutionChapter 3 Solutions
MODERN DATABASE MGMT.(PEARSON CHANNEL)
Additional Engineering Textbook Solutions
Starting Out with Programming Logic and Design (5th Edition) (What's New in Computer Science)
Management Information Systems: Managing the Digital Firm (15th Edition)
Introduction to Java Programming and Data Structures, Comprehensive Version (11th Edition)
Using MIS (10th Edition)
Database Concepts (8th Edition)
Java: An Introduction to Problem Solving and Programming (7th Edition)
- Draw an ER diagram and then map it into a relational schema(database) for the following scenario.• For each MEMBER we keep track of the unique MemdID, a well as Name, Zip, and the Datethe membership was paid.• For each MEMBERSHIP type we keep track of the unique Mid, as well as MName and Price• For each PASS CATEGORY we keep track of the unique PassCatID, as well as PCName andPrice• For each ONE DAY PASS we keep track of the unique PassID and Date• For each MERCHANDISE item we keep track of the unique MrchID, as well as Name andPrice• For each sale TRANSACTION we keep track of the unique Tid and Date• Each member pays for exactly one membership type; each membership type has at leastone member but can have many members.• Each member can buy many day passes but does not have to buy any, each day pass wasbought by exactly one member• Each day pass belongs to exactly one pass category; a pass category can have manyindividual day passes issued for it but does not have to have any. • Each…arrow_forwardA derived attribute can be stored in a table or calculated on each occasion that it is required. An example of a derived attribute is your Grade Point Average which is calculated by adding together a score for each unit (e.g., HD=4, D=3, C=2, P=1, N=0) and dividing that by the number of units you have completed. Explain how the decision as to whether the Grade Point Average would be stored in a table or calculated would be made. You are administering a database in a large retail company that records sales at each of the company’s stores. Tuning the database to improve performance by adding indexes and optimising query execution is an important ongoing aspect of the physical database design. Which attributes in a database such as this (apart from the primary key) are likely to BENEFIT from being indexed? Which attributes would you generally avoid indexing, and why?arrow_forwardER model relationships are represented using a.) relationship keys b.) primary keys c.) crows foot symbols d.) main keys What do the cardinalities in an ER model show, (please select all that apply)? a.) only a one to one relationship. b.) the minimum number of entities that can be involved in a relationship. c.) only a many to many relationship.arrow_forward
- In order to be used as a primary key, which of these characteristics must an attribute possess with respect to a single instance of the entity? There must be a maximum of one attribute instance. There must be many instances of the attribute. There must be at most one entity instance that each attribute instance describes. There must be at least one instance of the attribute. There must be zero or more instances of the attribute.arrow_forwardComputer Science Create the ER diagram for the following requirements and map it to relational model. Consider the participation (total/partial): A museum owns many works of art. Each work of art is described by an item code (identifier), title, type, and size; size is further composed of height, width, and weight. A work of art is developed by an artist, but the artist for some works is unknown. An artist is described by an artist ID (identifier), name, date of birth, and date of death (which is null for still living artists). Only data about artists for works currently owned by the museum are kept in the database. At any point in time, a work of art is either on display at the museum, held in storage, away from the museum as part of a traveling show, or on loan to another gallery. If on display at the museum, a work of art is also described by its location within the museum. A traveling show is described by a show ID (identifier), the city in which the show is currently appearing,…arrow_forwardA bank has three types of accounts: checking, savings, and loan. Following are the attributes for each type of account: CHECKING: Acct No, Date Opened, Balance, Service ChargeSAVINGS: Acct No, Date Opened, Balance, Interest RateLOAN: Acct No, Date Opened, Balance, Interest Rate,PaymentAssume that each bank account must be a member ofexactly one of these subtypes. Using generalization,develop an EER model segment to represent this situationusing the traditional EER notation, the Visio notation, or thesubtypes inside supertypes notation, as specified by yourinstructor. Remember to include a subtype discriminatorarrow_forward
- Study the following. A customer can place one or more orders, but an order belongs to only one customer. A customer is described by its name, delivery address, and contact number. While an order is described by order number, order status, and order date. Only one payment is made for an order. An order can be paid for through one of two options. A payment is either cash or debit. A payment has an amount attribute. Cash payment is described by cash tendered, while debit payment is described by number, type, and expiry date 6.1 Use the scenario to draw a UML class diagram.arrow_forwardPLZ help with the following: Create a Crow’s Foot ERD. Draw YOUR entity relationship diagram (ERD) to indicate entities, relationships, connectives, and resolve M:N relationships. For the following: The faculty and students (we refer to them in our system as clients) can electronically check out any book at any time. A book must have at least one author but can have more authors. An author must have written at least one book or more to be included in the system. A book may have neverbeen checked out, but can be checked out many times by the same client or different clients over time. A client may have never checked out a book or they may have checked out many books over time. To simplify determining which client currently has a given book checked out, a M:N relationship between BOOK and CLIENT should be maintained. The information recorded for each book is book number, book title, book subject, and year of publication. For each author, the library records the author ID,…arrow_forwardManufacturerA manufacturing company produces products. The following product information is stored: product name, product ID and quantity on hand. These products are made up of many components. Each component can be supplied by one or more suppliers. The following component information is kept: component ID, name, description, suppliers who supply them, and products in which they are used.Assumptions• A supplier can exist without providing components.• A component does not have to be associated with a supplier.• A component does not have to be associated with a product. Not all components are used in products.• A product cannot exist without components. Construct an ERD table to show how you would track this information.arrow_forward
- It is important to identify and describe the loT model reference model. Is it possible to write the four tiers of the reference model's connections?arrow_forwardSwing Jazz Club ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information. Remember the ERD will eventually turn into the design for a database from a top down view. Make sure you resolve any many to many conflicts. Label an identifier or primary key and all pertinent attributes given. If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular entity. Therefore, all entities should end up with at least an identifier and another attribute that makes sense. You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common. Make sure you show entities, relationships, cardinality, and optionality. Swing Jazz Club The Swing Jazz Club teaches swing and jazz dancing and offers both private and group lessons. Swing Jazz charges $60 dollars per hour for a private lesson and $10 dollars per hour for a group lesson.…arrow_forwardConsider the following dimensions, dimension attributes, and dimension sizes for Farm Coop-Insurance: Member(member_ID, Name, Address). On average, there are two members for each policy and item covered by the policy. InsuredItem(Item_ID, Description, Coverage_Type). There is an average of ten covered items per policy. CoopOffice(Office_ID, Address, Manager_name). Each policy is registered and managed by only one office of the cooperative. Policy(Policy_ID, Type). The company has approximately one million policies at the present time. Approximately five percent of these policies experience some change each month. Period(Date_Key, Fiscal_Period). The length of the fiscal period is one month. The decision system reports are supposed to be based on five years of data. Claim(Claim_ID, Claim_Description, Claim_Type). The facts to be recorded for each combination of these dimensions are Policy_Premium, Deductible, and Monthly_Claim_Total. Design a star schema for this problem. Using the…arrow_forward
- Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning