Hello, Please helps with part1, part 2 and part 5

I finished the assignment, but it seems not right

please advise and help

 

CSC 455: Database Processing for Large-Scale AnalyticsAssignment 1 – Alex ChouPart 1a)Create a relational schema with underlined (primary) keys and arrows connecting foreign keys andprimary keys for a database containing the following information. If you have any difficultydrawing arrows, you can write foreign key information in a sentence instead.•Authorshave Last Name, Firstname, ID, and Birthdate (identified by ID)•Publishershave Name, ID, address (identified by ID)•Bookshave ISBN, Title, Publisher (each book has a unique publisher and can be identified by ISBN).•AuthorsWriteBooks; since many authors can co-author a book, we need to know the rank of an authorcontributing to a book, stored in this table (i.e. a number 1, 2, 3; for single author books, this number is1).NOTE: Part 2 has some sample data which may be helpful.b)Create a relational schema for students and student advisorsStudentshave First Name, Last Name, DOB, Telephone and a reference to their advisorAdvisorshave ID, Name, Address, Research Area

Attachments:

• 1493086316-Assignment1-SQL.docx