[실습]
- 다음 기능에 대해 필요한 entity, field, relation을 ERD를 활용하여 설계하시오.
- 도서관 플랫폼 - 여러 도서관들의 장서를 관리 - 사용자의 대출 기록을 관리
도서관 플랫폼
Entity:
1. Library
2. Book
3. User
4. Loan
Fields:
1. Library: LibraryID (Primary Key), Name, Location, Contact
2. Book: BookID (Primary Key), Title, Author, Genre, AvailableCopies
3. User: UserID (Primary Key), Name, Email, Address
4. Loan: LoanID (Primary Key), UserID (Foreign Key), BookID (Foreign Key), DueDate, ReturnDate
- 온라인 쇼핑 플랫폼에 대해 필요한 entity, field, relation을 ERD를 활용하여 설계하시오.
온라인 쇼핑 플랫폼
Entity:
1. Customer
2. Product
3. Order
4. Payment
Fields:
1. Customer: CustomerID (Primary Key), Name, Email, Address
2. Product: ProductID (Primary Key), Name, Description, Price, StockQuantity
3. Order: OrderID (Primary Key), CustomerID (Foreign Key), OrderDate, TotalAmount
4. Payment: PaymentID (Primary Key), OrderID (Foreign Key), PaymentDate, Amount
- 임의의 SNS에 대해 필요한 entity, field, relation을 ERD를 활용하여 설계하시오.
임의의 SNS
Entity:
1. User
2. Post
3. Comment
4. Like
Fields:
1. User: UserID (Primary Key), Username, Email, Password, ProfilePicture
2. Post: PostID (Primary Key), UserID (Foreign Key), Content, PostDate
3. Comment: CommentID (Primary Key), PostID (Foreign Key), UserID (Foreign Key), Content, CommentDate
4. Like: LikeID (Primary Key), PostID (Foreign Key), UserID (Foreign Key), LikeDate
