SQL勉強をする前にデータベースの正規化の勉強をしておりまして、こちらの問題に対する自分自身の回答をきしいいたします。
もしよろしければFBをいただきたいです。
リンク内容
#下記自分のアンサーです。
Employee View
0NF
EmployeeNumber, SIN, Name, Address, City, PostalCode, WorkPhone, E-MailAddress, (EmployeeGroupCode, EmployeeGroupName, Wage)
1NF
EmployeeNumber, SIN, FirstName, LastName, Address, City, PostalCode, WorkPhone, E-MailAddress
EmployeeGroupCode, EmployeeGroupName, Wage, EmployeeNumber
2NF
EmployeeNumber, SIN, FirstName, LastName, Address, City, PostalCode, WorkPhone, E-MailAddress
EmployeeGroupCode, EmployeeGroupName, Wage, EmployeeNumber
3NF
EmployeeNumber, SIN, FirstName, LastName, Address, City, PostalCode, WorkPhone, E-MailAddress
EmployeeGroupCode, EmployeeGroupName, Wage, EmployeeNumber
Book Title View
0NF
ISBN, Title, SuggestedSellingPrice, QuantityOnHand, PublisherCode, PublisherName, (AutherCode, AutherName), CategoryCode, CategoryDescription
1NF
ISBN, Title, SuggestedSellingPrice, QuantityOnHand, PublisherCode, PublisherName, CategoryCode, CategoryDescription
AutherCode, AutherFirstName, AutherLastName, ISBN
2NF
ISBN, Title, SuggestedSellingPrice, QuantityOnHand, PublisherCode, PublisherName, CategoryCode, CategoryDescription
AutherCode, AutherFirstName, AutherLastName, ISBN
3NF
ISBN, Title, SuggestedSellingPrice, PublisherCode, CategoryCode
PublisherCode, PublisherName
CategoryCode, CategoryDescription
ISBN, QuantityOnHand
AutherCode, AutherFirstName, AutherLastName, ISBN
Sale View
0NF
SaleNumber, Date, Customer, CustomerNo, Employee, EmployeeNo, (ISBN, BookTitle, Price, Quantity, Amount), SubTotal, GST, Total
1NF
SaleNumber, Date, CustomerFirstName, CustomerLastName, CustomerNo, Address, City, Province, PostalCord , EmployeeFirstName EmployeeLastName, EmployeeNo, SubTotal, GST, Total
SaleNumber, ISBN, BookTitle, Price, Quantity, Amount
2NF
SaleNumber, Date, CustomerFirstName, CustomerLastName, CustomerNo, Address, City, Province, PostalCord, EmployeeFirstName EmployeeLastName, EmployeeNo, SubTotal, GST, Total
SaleNumber, ISBN, Quantity, Amount
ISBN, BookTitle, Price
3NF
SaleNumber, Date, CustomerNo, EmployeeNo, SubTotal, GST, Total
CustomerNo, CustomerFirstName, CustomerLastName, Address, City, Province, PostalCord
EmployeeNo, EmployeeFirstName EmployeeLastName
SaleNumber, ISBN, Price, Quantity, Amount
ISBN, BookTitle, Price
あなたの回答
tips
プレビュー