View 2 Seneca Courses Inc. Product Spreadsheet All the course books are maintained on the following Product spreadsheet. SCI is currently having difficulty searching for books written by the same author, and would like the new database system to list each author separately. There can be one or many authors for each book, but there is no limit to the number of authors of a book. PROD ID TITLE EDITION Purchase Cost Retail Price AUTHOR 100860 DATABASE SYSTEMS: DESIGN AND IMPLEMENTATION THIRD EDITION $84.98 $99.98 CARLOS CORONEL, PETER ROB 100861 DATABASE SYSTEMS: DESIGN AND IMPLEMENTATION FOURTH EDITION $92.82 $109.20 CARLOS CORONEL, PETER ROB 100871 MODERN RETAILING FOURTH EDITION $88.36 $110.45 DANIEL CASTON, JENNY TAPSCOTT 100890 UNDERSTANDING MICROSOFT ACCESS NINTH EDITION $65.52 $72.80 PIERRE LEBLAND, ROBERT COBB 102130 ORACLE: INTRODUCTION TO PL/SQL $53.24 $59.15 PHILIP ROBB 200376 ORACLE: ADVANCED PL/SQL DEVELOPMENT $64.26 $71.40 PHILIP ROBB, DAN CHEN Business Rules: 1. PURCHASE COST the default value is 0. 2. RETAIL PRICE must always have a value. Normalize the above user view. Document all steps including UNF, 1NF, Dependencies, 2NF, and 3NF and explain or list the primary key and foreign

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

View 2

Seneca Courses Inc.

Product Spreadsheet

All the course books are maintained on the following Product spreadsheet. SCI is currently having difficulty searching for books written by the same author, and would like the new database system to list each author separately. There can be one or many authors for each book, but there is no limit to the number of authors of a book.

PROD ID	TITLE	EDITION	Purchase Cost	Retail Price	AUTHOR
100860	DATABASE SYSTEMS: DESIGN AND IMPLEMENTATION	THIRD EDITION	$84.98	$99.98	CARLOS CORONEL, PETER ROB
100861	DATABASE SYSTEMS: DESIGN AND IMPLEMENTATION	FOURTH EDITION	$92.82	$109.20	CARLOS CORONEL, PETER ROB
100871	MODERN RETAILING	FOURTH EDITION	$88.36	$110.45	DANIEL CASTON, JENNY TAPSCOTT
100890	UNDERSTANDING MICROSOFT ACCESS	NINTH EDITION	$65.52	$72.80	PIERRE LEBLAND, ROBERT COBB
102130	ORACLE: INTRODUCTION TO PL/SQL		$53.24	$59.15	PHILIP ROBB
200376	ORACLE: ADVANCED PL/SQL DEVELOPMENT		$64.26	$71.40	PHILIP ROBB, DAN CHEN