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.

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.

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

Please, briefly describe Use Case "User Login to the System in UML (at least Use Case Model and/or Activity Diagram). The System ensures whether the User exists (has an account) and has the access to Default Screen, which is displayed to the User once the login is successful. If the User does not exist, the System allows to create a new account request on the separate screen. The request is then sent to the Administrator for confirmation. You can create more than one UC, if it makes sense to you. Briefly describe what kind of information you would expect as the developer for each step of the Use Case.
There has been a use case diagram posted for you below, just add more things to it. Please make sure to include "uses" and "extends" just like in the diagram below. Please also provide an explanation for the diagram (maybe explain all the associations).
O Using the Customer database (Customer Database has one table Customer), Create Class Library Project (Please note use project for creating C# class library) that Handles the CRUD Operation of Customers Project Create Class Library Project should contain the following O O BussinessObject DataAccessLayer ■ ■ ■ BussinessLogic Layer ■ ■ Customer Class Properties of Customers Class should match the columns of Customers Table. Insert Customer Insert Stored Procedure Update Customer Update Stored Procedure Delete Customer Delete Stored Procedure Select Customer By customerld Select Customer By customerld Select All Customer Select All Customers DBHelper Class Add Customer Update Customer Delete Customer Select Customer By customerld Select All Customer Customer BussinessLogic DataAccessLayer DBHelper Customer Id FirstName MiddleName LastName Street City State Zip Add Update Delete GetCustomer GetAllCustomers Add Update Delete GetCustomer GetAllCustomer
TASK 1: Create a State Chart Create a UML Class Diagram with Relationship (include Name, Attributes, and Operations) TASK 2: Create a Use Case Description using the template below: Use Case ID:Name:User:Description:Pre-condition:Post-Condition:Normal Flow:Alternate Flow:Exception Flow:Remarks (NonFunctional Requirement):
Task Description: Consider the following relations for a company: Department (Did: integer, Dname: string, location: string) Employee (Eid: integer, Ename: string, Erank: integer, salary: real, DepartmentID, integer) Project (Pid: integer, DepartmentID: integer, Pname: string, budget: real, start year: integer) The “DepartmentID” fields in both Employee and Project are foreign keys referencing the “Did”field of the Department table. Through Java application, use SQL to insert (random but meaningful) data records in the above tables:1) Create two different departments (named: Marketing and Human Resources)2) Create at least three employees per department (6 employees in total). A rank of an employee is an integer value between 1 and 3.3) Create at least three different projects per department (6 projects in total). The start year is between 2018 and 2020.
Device a category called Worker. The classification have to have blanketed records members: • Worker identify (string) • Worker wide variety (an integer) • Hire date (string)
1. Create an entity named Doctor and Patient and create a one-to-many mapping using JPA. Doctor_id Patient_id Qualifica Contact_ Salary Age no tion n Doctor treats Patient Name P_Name Address Write a main program to assign values to the Doctor and Patient entity using entity manager instance.
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.
Task Description: Consider the following relations for a company: Department (Did: integer, Dname: string, location: string) Employee (Eid: integer, Ename: string, Erank: integer, salary: real, DepartmentID, integer) Project (Pid: integer, DepartmentID: integer, Pname: string, budget: real, start year: integer) The “DepartmentID” fields in both Employee and Project are foreign keys referencing the “Did”field of the Department table. Use SQL to create a new database (named MyCompany), then use it to build the relations mentioned above. Place the constraints (e.g., default values) you find appropriate.
Q2/ write the schema that descibes the following relations: 1- The course relation course.id title deptname Biology Biology Biology Intro. to Computer Science Comp. Sci. Comp. Sci. Comp. Sci. Comp. Sci. Database System Concepts Comp. Sci. Elec. Eng. Finance History Music Physics credits BIO-101 Intro. to Biology 4 BIO-301 BIO-399 CS-101 CS-190 CS-315 CS-319 CS-347 EE-181 FIN-201 HIS-351 MU-199 Genetics 4 Computational Biology 4 4 Game Design Robotics Image Processing Intro. to Digital Systems Investment Banking World History Music Video Production Physical Principles PHY-101 2- The section relation course.id secid building rooIJumber timeslot.id semester ynar BIO-101 BIO-301 CS-101 CS-101 CS-190 CS-190 CS-315 CS-319 CS-319 CS-347 EE-181 1 Summer Summer Fall 2009 Painter 514 514 101 101 3128 2010 Painter 2009 Packard 1 Spring 1 Packard 2009 Taylor 2009 Taylor 2010 | Watson 2010 2010 Spring Spring E Spring 3128 120 100 3128 3128 Spring 2. Watson 2010 Taylor 2009 Taylor 2009 Taylor…
DATABASE
specify the type of cardinality in the figure below * Fname Minit Lname Bdate Address Salary Name San Sex Locations WORKS FOR Name Number EMPLOYEE Start date Number_of employees- DEPARTMENT MANAGES CONTROLS Hours WORKS ON PROJECT Supervisor Supervisee SUPERVISION Name Location DEPENDENTS OF Number DEPENDENT Name Sex Birth date Relationship