Student Database Problem – IT Computer Science Assignment Help

Assignment Task

Task 

Short Answer Questions
1. Explain the following data types and give an example of each. 
• String
• Int
• Float
• Double
• Char

2. Explain what SQL Injection is and give an example of how to prevent it.
3. What are the differences between multi-mode fibre optic and single mode fibre optic?

Application Tasks:
1. Consider the problem below.
Bob is the manager of a library and he would like to create a database system to manage book loans.
Each book has one or more authors, a title, an ISBN (unique) and a date of release.
Authors also have a unique ID, and a name stored in the database.
Each borrower has a name, a library card ID (unique), a phone number, and the date they joined.
When a borrower borrows a book the system will need to record the time that the book was borrowed, the due date, and the time it was returned (which is left as null).
Be aware that Bob may have multiple copies of the same book. Bob will print out his own unique barcodes to attach to each book so that the individual books can be tracked.
It may be a good idea to have a separate entity called BookCopy which stores bob’s barcode as its Primary key and also the date when that copy was added to the library.

A. Identify the possible entities in the student database problem. 
B. Identify the attributes in the student database problem. 
C. Identify how the entities relate to each other (the relationships)
D. Identify what attributes could be used as primary keys for each entity. 

2. If you want to make the tag of the “main” div blue,  what compound CSS selector should you have? This IT Computer Science Assignment has been solved by our IT Computer Science Expert at TV Assignment Help. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing Style. Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered.  You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.