### Using the Customer Database#### ObjectiveCreate a Class Library Project using the Customer database (which contains a single table named Customer) to handle CRUD operations within a Customer Project.#### Project RequirementsThe Class Library Project should include the following layers and components:### Business Object- **Customer Class** - The properties of the Customer class should align with the columns in the Customer table.### Data Access Layer- **Functions:** - **Insert Customer** - Implement an Insert Stored Procedure. - **Update Customer** - Implement an Update Stored Procedure. - **Delete Customer** - Implement a Delete Stored Procedure. - **Select Customer by CustomerId** - Access customer data using their CustomerId. - **Select All Customers** - Retrieve data for all customers.- **DBHelper Class**### Business Logic Layer- **Operations:** - **Add Customer** - **Update Customer** - **Delete Customer** - **Select Customer by CustomerId** - **Select All Customers**### Diagram Explanation1. **Customer Table Schema** - Columns: `CustomerId`, `FirstName`, `MiddleName`, `LastName`, `Street`, `City`, `State`, `Zip`.2. **BussinessLogic Layer (Blue Box)** - Contains methods such as Add, Update, Delete, GetCustomer, and GetAllCustomers.3. **Data Access Layer (Orange Box)** - Contains actionable methods: Add, Update, Delete, GetCustomer, and GetAllCustomers directly interacting with the database.4. **DBHelper (Gray Box)** - Supports Data Access Layer operations by providing database connection and execution functions.This setup ensures structured development and maintenance of CRUD operations for customer data handling.

Step 1To create a DatabaseTo build the "CoreMvDB Database," open your SQL Server with the following document.Step 2Create a TableTo build a "Tb Customer Table," open your SQL Server and use the following script.1 create Table tbl CustomerCustomerid int IDENTITY(1, 1) NOT NULL primary key.Name Varchar(20) NOT NULL, 4 Address varchar(100) not null,City Varchar(20) NOT NULLCountry Varchar(20) NOT NULL.Gender Varchar(6) NOT NULL, 8. MobileNo varchar(15) NOT NULL,9. Mailid varchar(20) NOT NULL)We can now create a saved system for adding, removing, updating and receiving customer information.Step 3 - To create a stored procedureNow a saved procedure is created to upload customer records into the database.Open your SQL Server to construct a process using the following scriptTo insert a CustomerRecord1. Create procedure sp AddCustomer( 2. @Name VARCHAR(20), 3. @Address varchar(100). @City VARCHAR(20), 6. @Country VARCHAR(20), 5. @Gender VARCHAR(6), 5. @MobileNo varchar(15), 6. @Mailld varchar(20)) 7. As 8. Begin 9. Insert into tbl Customer (Name, Address, City, Country, Gender MobileNo, Mailid) 10. Values (@Name@Address @City,@Country, @Gender,@MobileNo, @Maild) To Update a CustomerRecord 1. Create procedure sp UpdateCustomer( 2. @Customerld INTEGER, 3. @Name VARCHAR(20), 4. @Address varchar(100). 5. @City VARCHAR(20), 6. @Country VARCHAR (20), 7. @Gender VARCHAR(6), 9. @MobileNo varchar(15), 8. @Mailld varchar(20)) 9. As begin Update tbl Customer 10. set Name=@Name, 11. Address @Address, 12. City=@City. 13. Country @Country, 14. Gender-@Gender, 15. MobileNo=@MobileNo, 16. Mailld= @Maild 17. where Customerid=@Customerld To Delete a CustomerRecord 1. Create procedure sp Delete Customer( 2. @Customerld int) 4. As vou start to remove from tbl Customer where Customerld=@ Customerid To Get a Single CustomerRecord Create procedure sp. GetCustomerByID(@Customerld int) Begin SELECT FROM tbl Customer WHERE CustomerID=@Customerid To View All CustomerRecords Create procedure sp_GetAll Customers As Begin select Customerld, Name, Address, City, Country, Gender, MobileNo, Mailld from tbl Customer

Engineering

Computer Science

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 BussinessObject O O O ■ Customer Class DataAccessLayer BussinessLogic Layer Properties of Customers Class should match the columns of Customers Table. ■ Insert Customer Insert Stored Procedure Update Customer ■ Delete Customer Update Stored Procedure 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

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 BussinessObject O O O ■ Customer Class DataAccessLayer BussinessLogic Layer Properties of Customers Class should match the columns of Customers Table. ■ Insert Customer Insert Stored Procedure Update Customer ■ Delete Customer Update Stored Procedure 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

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

Break the list in Figure 1-31 into tables, each with a single theme. Create ID columns as you think necessary.
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.
Access Assignment Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70…
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.
In Visual Basics, ANTIQUE CAR COMPETITION DATABASE Design a Windows Application and write the code that will execute according to the program requirement below : ____________________________________________________________________________________________________ (i) The user views the Access database, which displays the car year model, and owner information. (ii) The user clicks the Add new button to add a new car and clicks the Save data button to save the item to the database. (iii) The user clicks the Delete button to delete a car, and permanently deletes the record from the database by clicking the Delete data button.
Code for the following: Web application is written using the MVC (Model, View, Controller) architecture Web application is written using object-oriented PHP programming, including classes for: Database Connection & Information Products table model Products table DB Products table controller Categories table model Categories table DB Categories table controller Web application includes 3 user interface pages: Index/landing/navigation page Title: "Your Name Wk 3 GP" Page Header: Your Name Product Information Includes navigation links to all other pages Filename index.php Database Connection Status page Title: "Your Name Wk 3 GP" Page Header: Your Name Database Status Includes: Text display of the database name Text display of the database user ID Text display of the database password Text display of the status of the connection (successful or unsuccessful) Navigation link to the home page Filename db_conn_status.php Products page (and Product Add/Update page) Title: "Your Name Wk 3…
import sqlite3 from sqlite3 import Error # Creates connection to sqlite in-memory database def create_connection(): """ Create a connection to in-memory database :return: Connection object """ try: conn = sqlite3.connect(":memory:") return conn except Error as e: print(e) # YOUR CODE HERE # Use sqlite3.connect(":memory:") to create connection object return conn # query to create the table table_sql = """ CREATE TABLE Horses ( id integer PRIMARY KEY NOT NULL, name text, breed text, height real, birthday text ); """ # query to insert data into the table ins_sql = """INSERT INTO Horses VALUES(1,'Babe','Quarter Horse',15.3,'2015-02-10'); """ # query to fetch all data from the table fetch_sql = """SELECT * FROM Horses;""" # creating db connection conn = create_connection() # fetching a cursor from the connection c = conn.cursor() # executing statement to create table c.execute(table_sql) # executing statement to…