Database

Describe how you would design a database to keep track of all the students at a university. describe tables, relationships, attributes, Primary Keys, Foreign Keys, Candidate Keys. Describe minimum and maximum cardinalities for each relationship. Make sure the database is normalized. Items to keep track of in database: fi ...continues

SQL Statements

Please see attached files. E. Given the database schema on the relations as follows: LIBRARY(LNO, LNAME, LOCATION) AUTHOR(ANO, ANAME) BOOK(BNO, TITLE, ANO) COPY(CNO, LNO, BNO) PATRON(PNO, PNAME, ADDRESS) LOAN(LOANNO, PNO, CNO) LNO – Library Number LNAME – Library Name ANO – Author Number BNO – Book Number CNO – ...continues

SQL statements and databases

This must be done in SQL Server 2005. In the first exercise, the Class field in the Part table should be a string of size 5, and not an int. 1- Write a statement that creates a table named Part, with an Id field as an int idendity primary key(PK), a SupplierId int field, a Description string field of size 25, a Count int f ...continues

Identification of serious data redundancy problems

Hi, I require support in the enclosed problem. Regards,

What problem would you encounter if you wanted to produce a listing by city?

Please see the attached file. Question 1: What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file structure? Question 2: What data redundancies do you detect, and how could these redundancies lead to anomalies?

Database - EMP_NAME and EMP_PHONE contents

Please see the attached file. Question 4: Looking at the EMP_NAME and EMP_PHONE contents in Figure P1.5, what change(s) would you recommend?

What problem would you encounter if you wanted to produce a listing by city?

Please see the attached file. What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file structure?

Databases - What problem would you encounter if you wanted to produce a listing by city?

Please see the attached file. Question 1 What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file structure? Question 2: What data redundancies do you detect, and how could these redundancies lead to anomalies? Question 3: Identify and discus ...continues

What new files should you create to help eliminate the data redundancies

Please see the attached file. Question 6: What new files should you create to help eliminate the data redundancies found in the file shown in Figure P1.5?

Databases - What problem might you encounter if building KOM were deleted?

Please see the attached file. Question 7: Given the file structure shown in Figure P1.9, what problem(s) might you encounter if building KOM were deleted? Identify each relationship type and write all the relationships.