Suppose a retail store has following two tables in the database: CUSTOMER (Cust-ID, Name, Phone, e-mail address) and SALES (T-ID, Product code, Date, Time), which represents the sales transaction. There is a one-to -many relationship between customer and sales that is one customer can do multiple sales transaction. For the data given here, do the following:a) Draw the tables for the CUSTOMER and SALESb) Identify the primary keys from these tablesc) Add the foreign key according to the one to…See More
This site is designed to assist the students all over the world to help them in their studies, We at Pakistan Universities Network will not allows the marketing of adult content such as pictures, videos, or anything else that would be considered offensive to Pakistan Universities Network rules & chat rules. If you are found to be in violation of this we will delete your profile immediately with no warning. You will not advertise, spam, abuse and discuss your problems in main chat room. Do you agree?
You need to be a member of Pakistan Universities Network to add comments!