DATABASE DESIGN ASSIGNMENT:

I need this assignment completed by 11PM today. It's for a Database Design SQL class. I've attached the document with instructions. I need work to be completed EXACTLY as specified in the the document. 

The answers can be written in the word document. 

 

Database Processing for Large-Scale AnalyticsAssignment 1Part 1a)Create a relational schema with underlined (primary) keys and arrows connecting foreign keysand primary 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 byISBN).ï‚·AuthorsWriteBooks; since many authors can co-author a book, we need to know the rank of anauthor contributing to a book, stored in this table (i.e. a number 1, 2, 3; for single author books,this number is 1).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 AreaPart 21)Using your logical schema from Part1-a, write the necessary SQL DDL script to create the tables. Besure to specify every primary key and every foreign key. You can make reasonableassumptionsregarding the attribute domains (note that uniformly setting every column toVARCHAR2(100)is notreasonable).2)Using logical schema from Part1-b write the necessary SQL DDL script to create the tables. Be sureto specify every primary key and every foreign key. ForStudentstable, clearly state the assumptionsyou have made when choosing a primary key. You can make reasonable assumptions regarding theattribute domains.3)Write SQL INSERT statements to populate your database from Part1-a with the following data(NOTE: remember that strings would need to use single quotes, e.g., 'Asimov')a)(King, Stephen, 2, September 9 1947)b)(Asimov, Isaac, 4, January 2 1920)

• 1494552462-SQLAssignment1.doc

ComputerScienceExpert

(11)

Status NEW Posted 12 May 2017 01:05 AM My Price 9.00

-----------

Attachments

file 1494552464-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer