Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

DATABASE

29/09/2020 Client: arwaabdullah Deadline: 24 Hours

   


                        1.5 Marks

                Learning     Outcome(s):

Create entity-relationship     model, relational model, and write SQL queries

 

 

 

 

 

 

      Question One


Consider the below schema for a library database and write relational algebra expressions for the following queries  


  


   


1. Author ( authorname, citizenship, birthyear) 


2. Book (isbn, title, authorname)


3. Topic (isbn, subject)


4. Branch (libname, city)


5. Instock (isbn, libname, quantity)




1. Give all authors’ names born after 1940. [0.25 Point]


2. Give the names of libraries in Sydney. [0.25 Point]


3. Give the city/cities and “isbn” where each book is held.    [0.25 Point]


4. Give the title of each book on the topic of either alcohol or drugs. [0.25 Point]


5. Give the title and author of each book of which at least two copies are held in a branch located in Melbourne.  [0.50 Point]








   


                        1 Mark

                Learning     Outcome(s):

Explain database concepts,     systems, and architectures

 

 

 

 

 

      Question Two


What is the different between the database schema and the database instance? Give an example for each.






   


                        1 Mark

                Learning     Outcome(s):

Design a database starting from     the conceptual design to the implementation of database schemas

 

 

 

 

 

      Question Three


Name at least three tables that might be used to store information in the following systems:


a. An e-commerce system such as Amazon.  [0.25 Point]


b. A social media system such as Twitter.    [0.25 Point]


c. A health care system. [0.25 Point]


d. A university system. [0.25 Point]




   


                        1.5 Marks

                Learning     Outcome(s):

Create entity-relationship     model, relational model, and write SQL queries

 

 

 

 

      Question Four


Given the relation below named Contact_Info, answer the following questions:


  


SSN




Name




Phone




Email




Age


 


234-356




Sara Fahad




340-675-9876




[email protected]




22


 


673-980




Mohammad Ahmed




234-896-2567




[email protected]




28


 


129-678




Waad Saud




280-986-8736




[email protected]




31


a. What is the relational schema of the relation Contact_Info?  [0.25 Point]



 


b. What is the degree of the giving relation? [0.25 Point]



 


c. Is the column Name an atomic attribute/value? If no, justify your answer? [0.25 Point]


d. What are the outputs of the given operations?  


1.                      (Contact_Info)  [0.50 Point]


2.   (Contact_Info)   [0.25 Point]

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Instant Assignments
Financial Hub
High Quality Assignments
Writer Writer Name Offer Chat
Instant Assignments

ONLINE

Instant Assignments

Good day dear client, I am a full-time freelance writer with years of experience. My strongest strengths are strong dedication to duty, reliability, quality and excellence. I am going to do an outstanding job for you, kindly PM me and let us commence. Thank you so much in anticipation of your positive response. Thank you very much.

$180 Chat With Writer
Financial Hub

ONLINE

Financial Hub

Hey, I have gone through your job posting and become very much interested in working with you.I can deliver professional content as per your requirements. I am a multi-skilled person with sound proficiency in the English language for being a native writer who worked on several similar projects of content writing and can deliver quality content to tight deadlines. I am available for both online and offline writing jobs with the promise of offering an incredibly responsive and supreme level of customer service. Thanks!

$180 Chat With Writer
High Quality Assignments

ONLINE

High Quality Assignments

With an extensive experience of over 10 years of writing and editing, I promise to meet or exceed your expectations. The days of automated, copied, plagiarized, and unethically optimized content are long gone. Today, you need engaging, well-researched, and optimized content that serves your SEO purpose and boosts your website ranking in the search engines. Not only this, you need EXCELLENT content that leaves a lasting impression on prospective customers and gives you an edge over the competition. This is exactly what I do.

$180 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

A periodic celebration mystic words - Nicholas bowen oil city - Skype for business codec bandwidth - What kind of symmetry does a hydra have - The physiology of stress - Our common bond book - 37 dudley street bardon - Discuss the challenges it divisions face in achieving regulatory compliance - Agassi company uses a job order cost system - 7 2 1 short answer ethics in humanities - Is banking tertiary or quaternary - Occupational therapy council of australia ltd - Transcript - Under what conditions will the government approve a merger - PPT - What does hpat stand for - Important scenes in v for vendetta - Creepage distance for 11kv - Commonwealth bank standard variable rate wealth package - Tell the story of a significant experience that contributed to your current relationship with learning something new in a particular context. - Litographs pride and prejudice - Criminal justice new policy MEMO - Cases studies - Hitta Gratis Ringsignaler - Så Här Gör Jag! - America's history concise edition 9th edition pdf - Traction definition drivers ed - Accident investigation techniques basic theories and applications - Are you looking for homework writers? - Case study myasthenia gravis patient - Only intended for wizard Kim - QUIZ - What is a research framework. Write a 250 words APA format paper that explains your understanding. - Assignment 2 - All my own work answers module 3 - How many stages are in each plant life cycle - Chlorine nitrate lewis structure - My virtual child paper 1 - MKT 1 - Everyone needs forgiveness the kindness of a savior - Disaster recovery plan - Film wall e watches - Roberta kathleen parks lafayette ca - Farewell to manzanar ending - How to count to 20 in french song - Sony mobile marketing strategy - Can a pmo accelerate the implementation process discussion - A dog's tale mark twain analysis - Milgram customs broker pars tracker - Early years planning cycle resource - Bullet the blue sky - 2012 vcaa physics exam - The drive reduction theory of motivation depends on - Ct pt unit connection diagram - Average variable cost curve explanation - Discussion - Human Rights Educational Flyer - Sundance solar company operates two factories - Help me... - Professional cover letter - What is lexical development - ACCT 221 HW 4 ASSIGNMENT - Annuity ba ii plus - Cells cells parts of the cell rap lyrics - Camshaft position actuator circuit bank 1 - Cloud Computing - Practical Connection - 5 hours - Which of the following is an example of an etic description of teen pregnancy in america? - Do plants grow better in sunlight or artificial light hypothesis - ETCM-Research-5 - Riddle vault of horus dominoes solution - C purlin floor joist span tables - Starbucks after schultz how to sustain a competitive advantage - Ratio analysis at s&s air inc - Peripheral Vascular Disease - Microeconomics - Ness corporation pty ltd - Dr muhammad virk auburn - Speech - Los angeles county chief executive office - Economic Assignment (2 days) - The company man ellen goodman thesis statement - Website Content Strategy - Tony benn arguments for socialism pdf - Markus prior news vs entertainment - Discussion question "Conflict with Teams", 350 words and 2 references. - Environmental Health - Evidence based practice proposal example - Cisco dx80 firmware upgrade - Personal development plan template nursing - Second order digital low pass filter - York st john library - eBay Evolves Case Study Essay - Ancient egyptian flying machines - Chelsi griffin myrtle beach - The family crucible chapter summary - Guinea dago figaro translation - Team Management Activity and Reflection - Civil systems major unimelb - Riello oil burner fault finding - Cloud computing data security research papers - Peter symonds college fees