Question: draw a database schema for the table in 3rd requirement 1) Design database schema and create database user pointOfSal that contain database schema tables with

draw a database schema for the table in 3rd requirement

1) Design database schema and create database user "pointOfSal" that contain database schema tables with its related relationships and database constraints 3) The system must contain tables such as category(catNo ,catogeryName) ,Items(itemNo,ItemName,Price,total_quantity, catNo), Items_stor_entry(entry_no number primary key,itemNo,entry_date ,quantity), Employee (employeeNo,employeeName,job) ,branch(No,Name), Customer(customerNo, costomerName,gender), , Invoice (employeeNo,customerNo,total price , invoiceNo,InvoiceDate, branchNo ) InvoiceDeatail contain List Of Purchase Items contain detail information related to the invoice (invoiceNo,ItemNo, paidPrice, quantity) . create getltemTotalPrice function which to return quantity*paidPrice

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

by using SQL COMMAND Q1) Create a complete project using SQL/PLSQL programing language to achieve the following requirement to develop point of sale system which allow the Employee to add customer...

pls use oracle PL/sql command line ------ Q1 ) Create a complete project using SQL/PLSQL program ing language to achieve the following requirement to develop point of sale system which allow the...

Q1 ) Create a complete project using SQL/PLSQL program ing language to achieve the following requirement to develop point of sale system which allow the Employee to add customer invoice which contain...

pls use oracle PL/sql command line ------- Q1 ) Create a complete project using SQL/PLSQL program ing language to achieve the following requirement to develop point of sale system which allow the...

Introduction to Coursework You are part of a consultancy company that specialises in the provision of database applications. The Director of FastCabs has recently approached your company to undertake...

Code needed for last two pages using primary and foreign key Creating a Relational Database Schema from ER Diagram and Populating the Database 1. BEFORE adding any PK Constraint or PK-FK Constraints...

Design and Implementation of a University Course Registration Database Introduction:This project involves designing and building a database system to support course registration at a university....

DATABASES You are required to design and implement a relational database to help the local community center better serve the residents in your neighborhood. Database Specifications: In your...

Design a Cassandra database to support a Spotify-like media cataloguing application. The application should catalogue music, including artists, their albums, songs in each album, playlists, users...

Why is it important for the tax planner to know the tax consequences of a particular transaction not only to the entity employing the tax planner but also to the other party (or parties) to the...

Given the character 1010010, what bit would be added to support even parity?

A company's current cash balance is $ 2 0 , 4 8 2 , 0 0 0 and cash flows from opera unchanged. They take ONLY the following actions relating to cash flows from activities: Issues 1 0 0 , 0 0 0 shares...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Consider your own personal opinions about ethical speaking. Would you add anything to the four principles noted here? If so, what characteristics would you cite?

3 Imagine that as the instructor or publisher, it is your responsibility to respond to an instance of plagiarism. How would you handle the situation?

Organizing Your Speech Points