The ABC Engineering (ABCE) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company's training program. The ABCE administrator gives you the description of the training group's operating environment. ABCE has 12 instructors and can handle up to 30 trainees per class ● It offers five Advanced Technology courses, each of which may generate several classes. If a class has fewer than 10 trainees, it will be canceled. Therefore, it is possible for a course not to generate any classes Each class is taught by one instructor Each instructor may teach up to two classes or may be assigned to do research only Each trainee may take up to two classes per year Complete the table to define all of the entities and relationships. First one is done for you. Consider one of the relations as a composite relationship. ENTITY INSTRUCTOR RELATIONSHIP Teaches CONNECTIVITY 1:M ENTITY CLASS

The ABC Engineering (ABCE) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company's training program. The ABCE administrator gives you the description of the training group's operating environment. ABCE has 12 instructors and can handle up to 30 trainees per class ● It offers five Advanced Technology courses, each of which may generate several classes. If a class has fewer than 10 trainees, it will be canceled. Therefore, it is possible for a course not to generate any classes Each class is taught by one instructor Each instructor may teach up to two classes or may be assigned to do research only Each trainee may take up to two classes per year Complete the table to define all of the entities and relationships. First one is done for you. Consider one of the relations as a composite relationship. ENTITY INSTRUCTOR RELATIONSHIP Teaches CONNECTIVITY 1:M ENTITY CLASS

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

TakeltAll Inc is a wholesaler company that has just opened up for business. They sell all kinds of technology devices at their store, ranging from graphics cards to fully kitted gaming motherboards. To help them develop the information system needed for their sales operations, they have hired you to design their database. They currently keep a wide variety of products at their warehouse. The usual information stored for each product includes name, manufacturer, and price, etc... Apart from keeping track of their products, they would like you also to keep track of the purchases made by their clients. Purchases made by clients are shown in invoices that list all the client's products and the quantities of each product. The price at which a product was bought should also be recorded at the purchase of the products. TakeltAll has two types of employees they would like to keep track of in their new information system. Namely sales agents and product managers. Each employee can either be a…
Gregory Adam owns multiple theatres across South Africa. As a lover af the performing arts, who would like to see the arts sector blossom, he has asked you to help him to develop a database for theatre management. The following information has been provided to you. The data that must be stored for each theatre include the theatre's name, city and the capacity (Le. how many people can be seated in the theatre). Each theatre has many artists working at the theatre and each artist works at only one theatre. There are three different types of artists that Gregory wishes to keep track of, namely, Musicians, Dancers and Actors. The attributes that all artists have in common are: Name and Surname. Each artist must be either a Musician, Dancer or Actor but cannot be any of them at once. Musicians have the instrument and genre in which they specialise. Dancers have a specific style they major in and the database should also keep track of their height. The database should, furthermore, keep…
You have been hired as an intern at the local community center. The center has a number of sports programs for youth. You have been asked to create a database to keep track of the programs and the youths who participate in these sports activities. The Community Center database must support the following requirements:i. For an activity, store its number and name, for example, 051, Track. Each activity has a cost associated with it.ii. For a participant, store his or her number, first name, and last name as well as the name, home telephone number, and cell telephone number of the parent or guardian primarily responsible for the participants.iii. One participant can enroll in many activities, and one activity can include many participants. One parent/guardian can have many participants.Based on these requirements:1. Identify and list the entities and attributes of those entities. 2. Identify and list the functional dependencies. 3. Without creating a set of dependency diagrams, write the…
In this assignment, you will develop a business/organizational case study and design a database that will meet the needs (or a subset of needs) of your business which is the healthcare industry, particularly hospitals. Your database must ultimately include at least 6 tables and at least 30 columns in total (it can contain more tables/columns if you would like or if your business case requires). You will only need to provide three rows of sample data for each database table. You will produce a report that describes the business needs that have led to the need for your database, details your business rules. Your report will also include both a conceptualand logical model of your database, as well as data dictionaries
The Acme Company wants to construct a database to keep track of the company’s employees, departments, and projects as well as the employee’s dependents. Draw the entity-relationship model. The requirements collected to date to be modeled are: The company is organized into departments. Each department has a name, a number, and an employee who manages the department. A department controls a number of projects, each of which has a name, a number, and a start date but not all departments have projects assigned to them. We store each employee’s name, social security number, address, salary, sex, and birth date. Every employee is assigned to a department but may work on several projects, which are not necessarily under the control of the same department. We keep track of the number of hours per week that each employee works on each project. For most projects, a team of employees is assigned to work on the project while some employees are never assigned to a project. We also keep track…
A student basketball club wants to keep track of their players, games, and teams for the season. The club currently has several teams, but players can only play on one team during the season. Multiple games will be played throughout the season, and each team will participate in multiple games, each against a different team. From this information, create an entity relationship diagram for a database that would help the basketball team tracks the season. I would prefer to have a handwritten picture or computer-generated picture. thank you!
A public sector hospital wants to automate its manual paper based operations to speed up the operations and facilitate its patients and staff members. For this purpose, they want to develop a database for their hospital management system to remove paper based records. Now, you are required to analyze the following scenario very carefully and draw entity relationship diagram (ERD) for the given system by identifying entities, attributes and relationship among these entities. A hospital consists of various specialized wards where each ward has its unique ID, name and capacity (total number of beds for patients in each ward). Multiple patients can be admitted in each ward on the recommendations of the doctor. Each doctor has a unique id, name, specialization and etc. Furthermore, a specialized team of doctors in each ward will take care of admitted patients and suggest treatment for the patients (such as medication, recommended tests, date of admission, and date of discharge). Each ward…
The administrators of Tiny College are so pleased with your design and implementation of their student registration and tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows:• Faculty members may use the vehicles owned by Tiny College for officially sanctioned travel. For example, the vehicles may be used by faculty members to travel to off-campus learning centers, to travel to locations at which research papers are presented, to transport students to officially sanctioned locations, and to travel for public service purposes. The vehicles used for such purposes are managed by Tiny College’s Travel Far But Slowly (TFBS) Center.• Using reservation forms, each department can reserve vehicles for its faculty, who are responsible for filling out the appropriate trip completion form at the end of a trip. The reservation form includes the expected departure date, vehicle type required,…
Dr. Jones, knowing that you are an intuitive database design student, has come to you with a possible database solution for his medical practice. He is interested in storing data related to his patients and the medications that they take. He specifically would like to keep track of the drug names, the drug price, the dosage each patient takes, and the dates that the medications were prescribed. He needs to be able to pull patient data quickly to make sure that each patient is taking the least medication to help their illness. Create business rules that might go with this scenario. Keep in mind that nouns (subjects) will become entities and their characteristics attributes. Verbs will translate into the relationships between entities. Create the ER diagram using Visio that would go with this scenario. Be sure to include entities, attributes, keys, and relationships using the crow’s feet notation
ALO (Anderson - left - overs.) Enterprises is an organization that provides a wide variety of service offerings for clients. Service types available include bookkeeping, computer installation, computer repair, software installation, taxes, advertising, market surveys, etc. Each service engagement may involve multiple types of service and may include multiple employees. Each type of service has a standard hourly billing rate and can not be entered into the database unless at least one of ALQ's employees is capable of performing that type of service. Employees are trained to perform multiple types of services and can work on multiple service engagements. Employees earn a contracted annual salary based on their credentials, regardless of what services they actually end up performing. Clients are required to pay for a given service engagement in full ( with just one check) within two weeks of the completion date. It is possible for a client to pay for more than one service engagement with…
Scenario You are a database consultant with Ace Software, Inc. and have been assigned to develop a database for the Mom and Pop Johnson Video Store in old-town. Mom and Pop have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database. You sit down with Mom and Pop to discuss their business and watch their operation for about a week. Mom and Pop rent legacy video/DVDs and discuss their need to move away from maintaining their rental records on paper. You discover for 1 title, they typically (but not always) offer two formats including a video (VCR) and DVD format. Both formats of a movie are kept in a separate plastic case when rented out. They have several copies of each rental movie. There are several videos and DVDs for each movie title. You learn that in their inventory, they have several thousand…
A database table is in 3rd normal form if A It is in 2nd normal form (2NF) and in 1" normal form(INF) B It is in 2NF and all non-key fields depend on all key fields C t is in 2NF and all non-key fields depend only on the key D It is in 2NF and all non-key fields may depend indirectly on all key fields.