Database assignment - Azure / .NET
Budget: $30 – $250 USD
You will build a database that in the future will be used to build a library.
The current table has been produced by the staff at the library and can be seen below. It then needs to be normalized.
Boklån <table title (book loan in english)
bok_id (book_id in english)
utlånad (on loan, rented)
boktitel (book title)
författare (author)
isbn
utgivningsår (release year)
betyg (score, grade)
lånekort (library card)
förnamn (first name)
efternamn (surname)
lånedatum Nullable (loan date)
returdatum Nullable (return date)
The requirements for the library
- The database must be able to store books and who authored them. A book can have several authors.
- Several of the same book can be found in the library.
- The database must be able to register a book as a loan and when it has been returned.
Task
Normalize the table so that all tables meet 3NF.
Create a diagram of the tables where primary keys, foreign keys and connection tables are located.
An interface where the Entity Framework generates the database based on the tables you have in the diagram. You are free to choose which interface (Console app, winforms web api etc.) you choose to use, but I recommend that you use a Web API and Postman.
The program must be able to do the following in order to get Approved:
- Create an author
- Create a book
- Create a new borrower
- Rent a goat
- Return a book
- Remove borrowers, books and authors
The current table has been produced by the staff at the library and can be seen below. It then needs to be normalized.
Boklån <table title (book loan in english)
bok_id (book_id in english)
utlånad (on loan, rented)
boktitel (book title)
författare (author)
isbn
utgivningsår (release year)
betyg (score, grade)
lånekort (library card)
förnamn (first name)
efternamn (surname)
lånedatum Nullable (loan date)
returdatum Nullable (return date)
The requirements for the library
- The database must be able to store books and who authored them. A book can have several authors.
- Several of the same book can be found in the library.
- The database must be able to register a book as a loan and when it has been returned.
Task
Normalize the table so that all tables meet 3NF.
Create a diagram of the tables where primary keys, foreign keys and connection tables are located.
An interface where the Entity Framework generates the database based on the tables you have in the diagram. You are free to choose which interface (Console app, winforms web api etc.) you choose to use, but I recommend that you use a Web API and Postman.
The program must be able to do the following in order to get Approved:
- Create an author
- Create a book
- Create a new borrower
- Rent a goat
- Return a book
- Remove borrowers, books and authors