Based on the following domain model class diagram, which statement is true:CustomerOrderOrderltemcustNumberitemiDorderlDorderDate1. quantitypricenamebillAddresshomePhoneofficePhoneamountplacesconsists ofO A. All of the answers are trueO B. An order consists of one or more order itemsO. A customer places zero or more ordersO D. An order item is part of exactly one orderO E. An order is placed by exactly one customer

The schema consists of different type of relationships.

Based on the following domain model class diagram, which statement is true: Customer Order Orderttem RemiD quantity price custNumber orderlD orderDate amount name billAddress homePhone officePhone places consists of O A All of the answers are true O B. An order consists of one or more order items OC. A customer places zero or more orders O D. An order item is part of exactly one order O E An order is placed by exactly one customer

Based on the following domain model class diagram, which statement is true: Customer Order Orderttem RemiD quantity price custNumber orderlD orderDate amount name billAddress homePhone officePhone places consists of O A All of the answers are true O B. An order consists of one or more order items OC. A customer places zero or more orders O D. An order item is part of exactly one order O E An order is placed by exactly one customer

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

In an annual charter day celebration of a university, one of the highlights of its celebration is having a concert for a cause in which national personalities were invited. The student body assigned for the conduct of the event, sold tickets for their fund raising for a cause. Tickets are sold according to the following prices. The green ticket is sold at $20, orange ticket at $30 and white ticket at $40. All students of the university are encouraged to support the said event, however the venue could only accommodate 1500 people. Write a Nassi-Shneiderman diagram that determines the total amount of money that will be generated if all tickets are all sold out and likewise print the total money collected.
In an annual charter day celebration of a university, one of the highlights of its celebration is having a concert for a cause in which national personalities were invited. The student body assigned for the conduct of the event, sold tickets for their fund raising for a cause. Tickets are sold according to the following prices. The green ticket is sold at $20, orange ticket at $30 and white ticket at $40. All students of the university are encouraged to support the said event, however the venue could only accommodate 1500 people. Write an algorithm in pseudocode, a flowchart and NS diagrams that determines the total amount of money that will be generated if all tickets are all sold out and likewise print the total money collected.
True or False : ___ Multiple Inheritance happens when a class has more than one sub-class. This problem can be observed in Programming Languages as well. ___ Given two relations named A and B, if we q-JOIN A and B, the maximum number of attributes in the result relation could be (the number of attributes of A) times(*) the number of attributes of B). ____ * in an SQL SELECT statement means “all the tuples”. ____ In relational algebra, Cartesian Product (X) can be implemented using the q-JOIN operator. Cartesian Product ISA q-JOIN where q-condition always evaluates to true. ____ SQL is based on Predicate Calculus. A query in SQL always specifies what should be included in the query result.
Given the following relation that stores details about students' activities: StudentID StudentName Activity ActivityFee AmountPaid 100 Jones Golf 65.00 65.00 100 Jones Skiing 200.00 0.00 200 Davis Skiing 200.00 0.00 200 Davis Swimming 50.00 50.00 300 Garrett Skiing 200.00 100.00 300 Garrett Swimming 50.00 50.00 400 Jones Golf 65.00 65.00 400 Jones Swimming 50.00 50.00 If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE. StudentID à StudentName StudentID , StudentName à Activity Activity à ActivityFee Activity à StudentID StudentID à Activity StudentID à AmountPaid
Customers ld Username Firstname Sumame Email PostalAddress Orders Id Customorld Created Status Orderitems Orderid StyleRequested SizeRequested Stockid Shirts Stockld Style Size StoreLocation Count Which of the following statements are correct for this entity rel ionship diagram? a. There is a many to many relationship between Orderitems and Orders Ob. There is a many to one relationship between Customers and Orders c. Orderltems is a bridge table Od. There is a many to one relationship between Orderitems and Shirts □e. Orders is a bridge table Of. There is a many to many relationship between Orderltems and Shirts
ObjectiveTo develop a simple database application using modern programming tools.ToolsStudents can choose either one of the programming languages C++, C#, Java, and Python as their main development platform. They can also choose either one of the database management systems SQLite, MySQL, PostgreSQL, and Microsoft SQL Server.GuidelinesEach student should agree to work with one student from the class as a teammate. Otherwise, the student works alone and gets penalized by getting at most 75% of the project grade. Teams should work independently toward the same project goal. Each team has to prepare a report presenting all the details about the work done and the job division. The number of pages should not pass twenty.Description of the ProjectThe project is to develop a simple university management system. The application should let three different kinds of users to work, namely, the student, the instructor, and the faculty coordinator. Users should have the following functionalities in…
Draw the domain class diagrams Scenario: Lillian’s Auto Works Lillian is the owner of Lillian’s Auto Works, a vehicle servicing center based in Gqeberha. Lillianrequires a new computerized Vehicle Servicing Record System (VSRS) - with a websitecomponent for private customers - to keep track of all customers and their vehicle’ serviceinformation. Lillian’s Auto Works’ customers can be private customers or companies.For private customers their id number must be submitted, whereas for companies their VATnumber is recorded. Each customer is allocated a unique customer number, and has a name,address and telephone number. Each customer can own many cars. The registration numberof the car uniquely identifies it, and the make, model and model year of the car must berecorded. A car is owned by only one customer. Customers bring their cars in for a service.A car can be brought in many times to be serviced.The system must keep information about Lillian’s employees. Details include employeenumber,…
Use C# to create Order class as follows: a. Data members: oid, orderDate, promised Date, shipDate, deliveryDate, amount, status. b. Behavioral members: isOnTime() - check if the delvieryDate is ahead of promised Date, timeToDelivery() - get number of days from order to delivery, getLate Fees() - company pays 1% fee to the customer for every day of delay in delivery according to the contract.
Synthesize the domain model of vending machine which has the following characteristics. Products can be purchased by inserting the correct number of coins into the machine. A user selects a product from a list of available products, adds coins, and either gets the product or gets the coins returned if insufficient money was supplied or if the product is sold out. Products can be restocked and money removed by an operator. Requirements for this system: Product Selection: Users will be able to choose a product from a list of available items. The system must display the product list with corresponding prices. Coin Insertion: Users can insert coins into the machine to pay for selected products. The machine will accept common denominations. Purchase Process: Upon sufficient coin insertion, the selected product will be dispensed. If the inserted coins are insufficient, the machine should return the coins. In case of a sold-out product, the machine will return coins. Restocking: Operators…
Use C# to create Order class as follows: a. Data members: oid, orderDate, promised Date, shipDate, deliveryDate, amount, status. b. Behavioral members: isOnTime() - check if the delvieryDate is ahead of promised Date, timeToDelivery() - get number of days from order to delivery, getLateFees() - company pays 1% fee to the customer for every day of delay in delivery according to the contract.
An Art Museum needs to keep track of its artwork and exhibitions. The museum has a collection of artwork. Each piece of art has a unique id [ArtID], an artist, year and title. Artwork is categorized by type. There are two types, paintings and sculptures. Paintings have a paintType and style. Sculptures have a material, height and weight. Artwork is frequently shown in exhibitions. Each exhibition has a unique name, startDate, endDate. A listing of the artwork displayed at an exhibition is also retained. Below is an E-R diagram for a database to help the Art Museum. Provide appropriate names for entities E1, E2, E3, E4 identifiers 11, 12, 13, 14 missing attributes and relationship cardinality RC1 and relationship type RT1. Start_date End_date E1 E1 11 RC1 PaintType Style E3 13 A1 Title Year A/ A A/ A/ A/ A/ A/ A/ A A/ A/ E2 12 A/ E2 E3 E4 11 12 13 14 A1 A2 RC1 RT1 RT1 A2 Height Weight E4 14 Activate Go to Settin
A restaurant maintains a menu for the list of food and beverage items that it provides.Apart from providing an on-premises dining facility, the restaurant takes orders online or over the phone for pickup or delivery.For on premises dining, a waitress/waiter is assigned. For delivery, a delivery person is assigned to deliver to the customer’s address. For pick-up, a vehicle color and make is required. A customer and his/her previous orders can be looked up by phone number to make future orders easier to make. Each order has a person’s first name. Draw ERD. Make sure to finalize all of the participation (mandatory/optional) and required fields as you feel they should be set.