CHAPTER 9Using cardinalities shown in the partial ER diagram, name the Foreign Key(s) (FK) that should be placed into the respective tables. If no foreign key is required in a table, then indicate NONE. Add any table(s) and Keys that may be needed CustomerSalesmanTableTable(PK) Customer Num(PK) Salesman NumNoneNoneCashReceiptsTableSales OrderTableMInventoryTable(PK) Cash Rec NumCustomer Num (FK)(PK) Invoice Num(PK) Part NumberCustomer Num (FK)Salesman Num (FK) M1NonePart Number (FK)M4SupplierTableLinkTable(PK) Part Number(PK) Vendor Num(PK) Vendor NumMNone

Table Name Foreign Key Customer Table None Salesman Table None Cash Receipts Table Customer…

CHAPTER 9 Using cardinalities shown in the partial ER diagram, name the Foreign Key(s) (FK) that should be placed into the respective tables. If no foreign key is required in a table, then indicate NONE. Add any table(s) and Keys that may be needed

CHAPTER 9 Using cardinalities shown in the partial ER diagram, name the Foreign Key(s) (FK) that should be placed into the respective tables. If no foreign key is required in a table, then indicate NONE. Add any table(s) and Keys that may be needed

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 4RQ

See similar textbooks

Similar questions

using PHP and MYSQL create a web based PIZZA ORDERING SYSTEM - The customer orders, the admin can see the order of the customer - the admin will decide whether he/she will accept the order or not and the customer will be notified - the customer can cancel order then the admin will be notified by the cancellation
For below given Scenario draw the following UML Diagrams CLASS DIAGRAM SEQUENCE DIAGRAM The Buyer has already bid for the product. A message is displayed to the user that he has already bid for the product The system admin is provided with a page where the top level categories of products are displayed. If the system admin wishes to add a new top level category, he clicks on ‘add category’ button and adds a new category The system admin can browse to a specific level and then click on ‘add category’ button and add a new category at any level An already existing category is again added, an error message is provided to the user.
Draw EER diagram based on these business rules Customers can only make a reservation for themself and their invited guests. A customer may not make a reservation for other people including such as reselling rooms. A customer cannot use Park Hyatt website to reserve room related to any commercial activity. A customer need to provide the ID card or passport. A customer must check-in after 4 p.m. A customer must check-out before 12 p.m. A customer may select room before do the reservation. A customer can do online payment by credit card or pay while during check-in. A staff must check the customer ID card or passport.
Many-to-Many ERD CUSTOMER has: customer_id first and last names address TAPE has: tape_id title description length in minutes A CUSTOMER may rent many TAPEs. A TAPE can be rented by many CUSTOMERs. Draw a Crow’s Foot ERD that includes the bridge table between Customer and Tape to account fully for the many-to-many relationship. Course and Class ERD Table name: COURSE COURSE_ID TITLE DESCRIPTION CREDITS ACCT-211 Basic Accounting An introduction to accounting. Required of all business majors. 3 CIS-380 Database Systems I Database design and implementation issues. Uses CASE tools to generate designs and implement in a major RDBMS. 3 CIS-490 Database Systems II The second half of CIS-380. Basic Web database application development and management issues. 4 Table name: CLASS CLASS_ID COURSE_ID SECTION TIME LOCATION 100 ACCT-211 1 8:00 a.m. – 9:30 a.m. T-Th. AA 325 101 ACCT-211 2…
Computer Science Please create the activity model for stock trade order Hint: verify order, send confirmation, …, close order
5- The assignment model is a special case of the transportation model in which the number of origin must equal the number of the destination that is the table is a square that is the number of rows and columns must be equal. Select one: True False 6- The points on the network model are referred to as arcs. Select one: True False
Draw a partitioned activity diagram for the rent car use case of Rent-A-Car. Rent-A-Car company has a website through which a user is allowed to book and pay for their rental cars. When a customer makes a request to rent a car the customer is presented with different car models from the catalog. The customer selects a model. The system checks if a car is available for the model selected. If a particular car is not available, the customer is requested to choose a different model. If the chosen model is available, the rental price is displayed to the customer. The customer needs to confirm if they would like to proceed with renting the car at that price or would like to opt for a different model. If the customer decides to proceed with booking the car, they must upload their driver’s license for verification. The driver’s license is verified by a staff member once it is uploaded. Only if the license is valid, does the system deduct payment and deposit from the clients credit card. If…
A company has various rules for how payments to suppliers are to be authorized.Some payments are in response to an approved purchase order. For approved purchase orders under $5,000, the accountingclerk can immediately issue a check againstthat purchase order and sign the check. Forapproved purchase orders between $5,000and $10,000, the accounting clerk can immediately issue a check but must additionallyobtain a second signature. Payments for approved purchase orders over $10,000 alwaysrequire the approval of the accounting manager to issue the check as well as the signature of two accounting clerks. Payments thatare not covered by a purchase order that areunder $5,000 must be approved by the accounting manager and a departmental manager who will absorb the cost of the paymentinto that department’s budget. Such checkscan be signed by a single accounting clerk.Payments that are not covered by a purchaseorder that are between $5,000 and $10,000must be approved by the accounting…
TopText Publishing is a textbook publishing company with a headquarters location, a warehouse, and three sales offices that each has a sales manager and sales reps. TopText sells to schools, colleges,and individual customers. Many authors write more than one book for TopText, and more than one author writes some books. TopText maintains an active list of more than 100 books, each identified by a universal code called an ISBN. How would you draw an ERD for the TopText information system, including cardinality notation? Show enough details for full credit.
TopText Publishing is a textbook publishing company with a headquarters location, a warehouse, and three sales offices that each has a sales manager and sales reps. TopText sells to schools, colleges,and individual customers. Many authors write more than one book for TopText, and more than one author writes some books. TopText maintains an active list of more than 100 books, each identified by a universal code called an ISBN. How would you draw an ERD for the TopText information system, including cardinality notation?
Database homework_1SCENARIO A manufacturing company produce equipments and sell them. The company needs a system to manage stock operations. It is explained below. Equipments are manufactured by using parts. Name, manufacturing date, current status of manufacturing must be known. Some of the equipments must be tested.We want to define all parts with their name, description and type. Only the defined parts can be bought. Once parts are bought, they are located into shelves in warehouses. Each physical part uniquely identified with number. We want to know when each part is bought. Each bought part may have different warranty period. We have to use the bought part in manufacturing by taking this into account.Warehouses are located in different part of the company. Size, type of the warehouses may be different. Each parts can be bought from same or different suppliers. We want to know in which city they are located. Also for how many years we are working with each supplier. We also give…
A food based company wants their users to rate their newly launched food items, items are Burger, Broast, Rice, Roll, Handi, Platter, Kebabs, Sandwich, Shake, Kheer. Scoring can be done from 1 to 10, best towards worst respectively. Design a solution that saves the food items and then let users rate these food items along with their comments. A bar graph based on rating should also be printed Note: (Structures must be used to save the data) A sample run of the application is shown as follows: Enter score for Burger (1-10) 8 Enter reason for liking or disliking Fresh and juicy