another example is for each book,list its code,title,publisher code, name, and price
so a boook table(BookID, Book_Code,Book_Name, Publisher_Code,Publisher_Name, Publisher_Price)
another example is for each college, list the number, name, location, and number of employees working at the bookstore.
Would i do something on the lines of this
College as Table (CollegeID,College_Name,College_Location,Employee)
Ok lets say I am given a this information
for each publisher,list the publisher code,publisher name, and city where publisher is located
would i do something on the lines of this
Publisher as Table (PublisherId as primary key ,Publisher_Code,Publisher_Name, City)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.