MODERN DATABASE MGMT.(PEARSON CHANNEL)
13th Edition
ISBN: 9780136709299
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 8, Problem 8.61PAE
Program Plan Intro
Indexes for the given
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
In this phase each student will select a real life problem that can be solved using database systems. Once you pick your project, start by writing a small description no more than 1 page to explain the project description. In this phase a project description is required only.
In this 2ND phase all you have to complete is preparing the UML diagram for the project that you have selected in Phase I
Draw an E-R diagram for each of the descriptions below.
Q -An architectural design firm has a number of design projects underway at any point in time. Each of these projects is identified by a unique project identification code. Additional data stored for each project includes a description, a target completion date, and a dollar budget amount. Design associates staff these projects. These associates include architects, engineers, and computer CAD (Computer-Aided Design) specialists. Each associate is identified by a unique code. Other information about associates includes their name, specialty, their level. There are three levels of associates (gold, silver, and bronze). The bronze associates report to one and only one silver associate (who typically has at least one bronze associates reporting to her), and the silver associate reports to a gold associate in the same fashion. Each project staffed by at least one associate staff. It is also common to find any particular associate…
Determine the highest normal form (1NF, 2NF, 3NF, or BCNF) for each one of the following six relations.
Notice that the primary key of each relation is underlined.)
1
2
3
4
5
6
Relations
Work (EmpNumber, ProjectNumber)
Work (EmpNumber, ProjectNumber, ManagerSSN)
Given that a project has one manager only.
Work (EmpNumber, ProjectNumber, HoursPerWeek)
Work (EmpNumber, ProjectNumber, EmpName, Location)
Given that a project is located in one location only.
Work (EmpNumber, ProjectNumber, Location)
Given that a project is located in one location only.
Work (EmpNumber, ProjectNumber, Location)
Given that a location has one project only.
Answers
Chapter 8 Solutions
MODERN DATABASE MGMT.(PEARSON CHANNEL)
Ch. 8 - Prob. 8.1RQCh. 8 - Prob. 8.2RQCh. 8 - Prob. 8.3RQCh. 8 - Prob. 8.4RQCh. 8 - Prob. 8.5RQCh. 8 - Prob. 8.6RQCh. 8 - Prob. 8.7RQCh. 8 - Prob. 8.8RQCh. 8 - Explain why you sometimes have to reserve much...Ch. 8 - Why are field values sometimes coded?
Ch. 8 - Prob. 8.11RQCh. 8 - Prob. 8.12RQCh. 8 - Explain why normalized relations may not comprise...Ch. 8 - Prob. 8.14RQCh. 8 - List three common situations that suggest that...Ch. 8 - Explain the reasons why some experts are against...Ch. 8 - Prob. 8.17RQCh. 8 - Prob. 8.18RQCh. 8 - Prob. 8.19RQCh. 8 - Prob. 8.20RQCh. 8 - Prob. 8.21RQCh. 8 - Prob. 8.22RQCh. 8 - One of the strongest recommendations regarding...Ch. 8 - Explain why an index is useful only if there is...Ch. 8 - Indexing can clearly be very beneficial. Why...Ch. 8 - Prob. 8.26RQCh. 8 - Prob. 8.27RQCh. 8 - Describe the role of data dictionary in the...Ch. 8 - Prob. 8.29RQCh. 8 - Prob. 8.30RQCh. 8 - Explain how creating a view may increase data...Ch. 8 - Prob. 8.32RQCh. 8 - Prob. 8.33RQCh. 8 - Prob. 8.34RQCh. 8 - Prob. 8.35RQCh. 8 - Prob. 8.36RQCh. 8 - Prob. 8.37RQCh. 8 - Prob. 8.38RQCh. 8 - Prob. 8.39RQCh. 8 - How can views be used as part of data security?...Ch. 8 - Prob. 8.41RQCh. 8 - Prob. 8.42RQCh. 8 - Consider the following two relations for...Ch. 8 - Prob. 8.44PAECh. 8 - Prob. 8.45PAECh. 8 - Prob. 8.46PAECh. 8 - Prob. 8.47PAECh. 8 - Suppose you are designing a default value for the...Ch. 8 - When a student has not chosen a major at a...Ch. 8 - Prob. 8.50PAECh. 8 - Prob. 8.51PAECh. 8 - Consider the relations in Problem and Exercise...Ch. 8 - Prob. 8.53PAECh. 8 - Prob. 8.54PAECh. 8 - Prob. 8.55PAECh. 8 - Prob. 8.56PAECh. 8 - Prob. 8.57PAECh. 8 - Consider the relations specified in Problem and...Ch. 8 - Prob. 8.59PAECh. 8 - Prob. 8.60PAECh. 8 - Prob. 8.61PAECh. 8 - Prob. 8.62PAECh. 8 - Prob. 8.63PAECh. 8 - Prob. 8.64PAECh. 8 - Problems and Exercises 8-65 through 8-68 refer to...Ch. 8 - Prob. 8.66PAECh. 8 - Problems and Exercises 8-65i5 through 8-68 refer...Ch. 8 - Refer to Figure 4-5 0. For each of the following...Ch. 8 - Prob. 8.69PAECh. 8 - Prob. 8.70PAECh. 8 - Prob. 8.71PAECh. 8 - Prob. 8.72PAECh. 8 - Prob. 8.73PAECh. 8 - Prob. 8.74PAECh. 8 - Prob. 8.75PAECh. 8 - Prob. 8.76PAECh. 8 - Prob. 8.77PAE
Knowledge Booster
Similar questions
- You are commissioned by AAA Review Center to conduct a four hour review session among the teacher education graduates. You are assigned to discuss the topic, “Discontinuity of functions”. On a one whole sheet of paper, make a review material with all the concepts, examples and illustration about the topic on itarrow_forwardA small training college has decided to extend and replace its existing database system. The project has received board approval and the required functional changes and additional requirements have been agreed with the users. A project manager has been appointed and has been allocated a project team of three database analysts, three development programmers and one tester, with selected users being made available for acceptance testing. An outline project schedule for the development and implementation phases has been drawn up. It includes the following tasks and related staff allocations. Task Description Duration (weeks) Staff A Define required new database functionality 4 Database Analyst DA1 B Define new data entry and update requirements 3 Database Analyst DA2 C Define new data analysis and report outputs 3 Database Analyst DA3 D Define database transfer rules 2 Database Analyst DA3 E Code and test extended database tables…arrow_forwardThe company is organized intoDEPARTMENTs. Each department has a name, number and an employee who manages the department.Each department controls a number of PROJECTs. Each project has a name, number and is located at a single location.We store each EMPLOYEE's social security number, address, salary, sex, and birthdate. Each employee works for one department but may work on several projects. ER diagram??arrow_forward
- A company has a number of employees. The attributes of FEMPLOYEE include Employee io (identifier), Name, Address, and Birthdate. The company also has several prolects. Attributes of (PROJECT include Project ID (identfier), Project Name, and Start Date. Each employee maybeassigned tp one or more projects or may not be assigned to a project. A project must have at least one emplovee assigned and may have any number of employees assigned. An employee's billing rate may vary by project, and the company wishes to record the applicable billing rate (Billing Rate) for each employee when assigned to a particular project. A). Draw ER Model For the companyB). Do the attribute names in this description follow the guidelines for naming attributes? If not, suggest better names.C). do you have any associative entities on your ERD? If so, what are the identifers for those associative entities?arrow_forwardA company has a number of employees. The attributes of FEMPLOYEE include Employee io (identifier), Name, Address, and Birthdate. The company also has several prolects. Attributes of (PROJECT include Project ID (identfier), Project Name, and Start Date. Each employee maybeassigned tp one or more projects or may not be assigned to a project. A project must have at least one emplovee assigned and may have any number of employees assigned. An employee's billing rate may vary by project, and the company wishes to record the applicable billing rate (Billing Rate) for each employee when assigned to a particular project. A. Draw ER Model For the company B. Do the attribute names in this description follow the guidelines for naming attributes? If not, suggest better names. C. to youhave any associative entities on your ERD? If so, what are the identifers for those associative entities?arrow_forwardA college course may have one or more scheduled sections or may not have a scheduled section. Attributes of COURSE include Course ID, Course Name, and Units. Attributes of SECTION include Section Number and Semester ID. Semester ID is composed of two parts: Semester and Year. Section Number is an integer (such as 1 or 2) that distinguishes one section from another for the same course but does not uniquely identify a section. How did you model SECTION? Why did you choose this way versus alternative ways to model SECTION?arrow_forward
- Design the Entity Relationship Diagram (ERD) showing entities, attributes, primary key and relationship cardinality for the following scenario. Any employee works for only a department and under supervision of a manager (where manager is also an employee). Employee's address, city code & city name also has been recorded. Every employee may work for multiple project, but an employee may be on vacation and not assigned to any projects. Working hour may be different for an employee for different projects. Projects are broken into tasks; A task is created for one project and assigned to one department. Requisitions are made for projects; Each requisition could ask for any number of items; Items could be: equipment item or materials item and are coded in a similar way; Each requisition is for one project and is made to one supplier. The important data fields are employee_id, employee_name ,employee_address, employee_email, department_id, department_name, location, city_code, city_name,…arrow_forwardIN MYSQL 1. In this phase each student will select a real life problem that can be solved using database systems. Once you pick your project, start by writing a small description no more than 1 page to explain the project description. In this phase a project description is required only. 2 . In this phase all you have to complete is preparing the UML diagram for the project that you have selected in Phase I. 3. Using the UML designed in phase II create all the necessary tables for your database system. 4. Write the update, insert, select, and delete statements for each table. IN MYSQLarrow_forwardComputer Science THREE TABLES: 1. PROJECT WORKER_TABLE COLUMNS leavedate, worker_id, joindate, project_id, performance 2. PROJECTS TABLE COLUMNS projectid, project_name, capacity, startdate 3. WORKERS table COLUMNS worker_id, worker_name, gender, companyjoindate, birthdate, birthday, supervisory_id USE MYSQL TO ANSWER QUESTION BELOW Q: Find the ID and name of the project(s) that have a gender ratio of greater than one[Gender ratio = #of females/# of males]arrow_forward
- List the changes needed to make the requirements change so a student can have more than one advisor and list the changes needed to make the requirements change so that you must store the year and the semester in which a student took a course and received a grade.arrow_forwardWhat is date flow diagram components?arrow_forwardPerform the following activities as part of the assignment • Read the case study at the end of Chapter 5, (which I will include below). You should use the 4 questions for the case study as a guide to the following: • Add new resort use case • Add book reservation use case • Activity diagrams • Sequence diagrams CRUD analysis. • Remember tables and diagrams always need a narrative to elaborate on them. This is what makes your document a narrative business document and not just a list of facts and ideas. Here is the case study. The Spring Breaks 'R' Us Travel Service The SBRU information system includes four subsys- they only plan to provide some design specifications and tems: Resort relations, Student booking, Accounting guidelines to each resort. The resort will be responsible and finance, and Social networking. The first three for connecting to the Internet and for providing a secur are purely Web applications, so access to those occurs wireless environment for the students.…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgramming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:Cengage
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr