![EBK SYSTEMS ANALYSIS AND DESIGN](https://www.bartleby.com/isbn_cover_images/8220102795068/8220102795068_largeCoverImage.jpg)
EBK SYSTEMS ANALYSIS AND DESIGN
11th Edition
ISBN: 8220102795068
Author: ROSENBLATT
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Question
Chapter 9, Problem 3DT
Program Plan Intro
Identify the possible candidate keys, the likely primary key, a probable foreign key, and a potential secondary key for the given situation.
Expert Solution & Answer
![Check Mark](/static/check-mark.png)
Trending nowThis is a popular solution!
![Blurred answer](/static/blurred-answer.jpg)
Students have asked these similar questions
If an employee can work for only one department and a department can have many employees (one to many relationship). Which answer the relationship table "work" that has the best
values to describe the relationship between employee and department?
The employee table has two columns (eid, name) with records ('E1','A'), ('E2','B'), ('E3','C').
The department table has two columns (did, name) with records ('D1','X'), ('D2','Y'), ('D3', 'Z').
work(eid, did) with values ('E1','D1'), ('E1','D2'), ('E2,'D2').
work(eid, did) with values ('E1','D1'), ('E2','D2'), ('E3,'D2').
work(eid, did) with values ('E1','D1'), ('E2','D2'), ('E2,'D3').
work(eid, did) with values ('E1','D1'), ('E2','D2'), ('E3,'D3').
ERD for Sales Order
Step 1.
Draw an ER diagram for the story below. Use the ERD tool only. Draw Relations in Oracle notation.
Please read the story carefully. Use the mentioned Entities ONLY.
The company sells various Products to Customers. The Sales Agent books an Order. A new order is created for each Product.
While booking an Order, Agent records Order Date, Product, Customer, Product Quantity, and Sales Agent.
Product has Description and UnitPrice.
Each Agent reports to a Manager. A Manger has a Nameand Commission Percent.
NOTE: Total Amount is a calculation, doesn't belong to Order
Step 2.
Add Attributes to Sales Order ERD based on Rules of Normalization.
Closely examine the following tables and use it to answer the questions that follow:
department
course
student_type
student_category
Student
registration
registration_type
Suppose that the following are true:
- all id column are primary keys in whichever table they are
- the dept_id in course table is foreign key that is referencing the id column in the department table
- the foreign keys stud_type_id, stud_cat_id in the student table are referencing the id columns
in the student_type and student_category tables respectively.
- the coursecode and stud_id columns in the registration table are foreign keys in the course
and student tables respectively.
1. Design an Entity Relationship Diagram for the system above.
2. Write query that would return the names and contacts of all Local students.
3. Write a query that would return names, contact and locations of all departments that has a
location text with Ave 3 as part of it. [hint: use the LIKE clause with “_” or “%”]
4. What would…
Knowledge Booster
Similar questions
- Based on the following ER model and business rules, write an SQL statement to create COURSE and COURSE_PREREQ table. Be sure to implement all related data integrity constraint. For each column, use the data type as you think appropriate. Business rule • A course may have more than one prerequisites. The prerequisite courses may have their own prerequisite courses (more than one). COUSE entity • CourseNo is a UID (unique identifier). • Credit hours should be greater than 0 and less than 7. COURSE_PREREQ entity • UID is the composite of CourseNo and CourseNo (i.e., prerequisite courseNo). COURSE COURSE_PREREQ CourseNo: UID Title Description CourseNo: LCourseNo: UID CreditHoursarrow_forwardIn a table: Worker ( Id number, First, Last, DOB, Email) -Which key is the first name A.Non-unique key B. Candidate key C. Primary key D. Foreign key E. Unique keyarrow_forwardUse the query box below to answer the questions, saving your query for each question. When you are done, submit your exam for grading. establishment license_no dba_name aka_name facility_type risk_level address city state zip latitude longitude employee employee_id- first_name last_name address city state zip phone title salary supervisor violation inspection_id point_id fine inspector_comment inspection inspection_id inspection_date inspection_type results employee_id license_no followup_to inspection_point point_id Description category code fine point_level List the inspections (inspection_id) with their date and type for all inspections that had a violation in the category of personnel' for January 2016. Also print the description of the inspection_point that was violated.arrow_forward
- How do primary key, candidate key, and superkey differ?arrow_forwardhow is the ProductID field in the Product table specified to be required? Why is it a required attribute?arrow_forwardThe Entity Relationship Data Model (Identify the primary key and the foreign key) Represent the different join(inner join, outer joins). Upload the diagram and result of your design query of joins. by using SQL applicationsarrow_forward
- Create a Star Schema ERD for the Bob’s Fixit case study. Create the tables (create table DDL) from your Star Schema ERD. Bob would like to know the following: The bid dollar amount by the customer zip code and customer state. The bid dollar amount by the bid month and bid year.arrow_forwardBased on the following ER Model, write SQL statements to create the tables. Include all the necessary integrity constraints: entity integrity, key constraint and referential integrity constraint. RoomType should be one of the three values: Classroom, ConferenceRoom, or Office. For each column, use the data type and the length as you think appropriate. BUILDING ROOM has BuildingCode: UID BName RoomNo: UID RoomType RoomLocationarrow_forwardWhat is the definition of the Candidate key?arrow_forward
- Question 2 Refer to the sample tables below. Tables: adult (id(pk), name, spouse_id(fk)) foreign key (spouse id) references adult(id) -- child (id(pk), name) Fill in the blank: The foreign key in the table adult is called a foreign key. • Previousarrow_forwardExplain Primary Key?arrow_forwardThe value range of an attribute must be large enough for the index to be relevant. Except for this one use case, an index is never helpful.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:CengageA 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
![Text book image](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr