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

Operational Excellence: Information Systems for Business and Beyond Questions - Strayer university acc 100 syllabus - Assignment 4: Workplace Ethics - 3 wire sensor connection - RE: Applied quantitative method - Armidale catholic schools office - Separation of mixtures post lab answers - Americanenglish state gov the gift of the magi - Diversity and culture - Lord of the flies chapter 11 vocabulary - The gambler who blew $127 million - Factset excel add in download - Disuccsion - School models issue number 4 - Sap solution composer download - Major service with accompanying minor goods and services - The Chief of police has asked you to create a PowerPoint presentation based on the research findings. Your presentation consists of the current and future criminal justice technology, examples and the benefits to your department. - Binocular cues ap psychology - Incremental benefit cost analysis example - How do i cite ana code of ethics in apa - 85 pounds in euro - Prodelin 3.8 m antenna manual - What color is ammonia liquid - Supply Chain Management - Winn dixie code of ethics - Cengage pop up blocker instructions - Straighterline college algebra final exam - Project procurement management mainly involves - Assignment - Soundtraxx tsunami steam cv list - What is the element of music - Special education and learning disabilities through social science lens - Unsw canberra key dates - Bakers jewelry rushville illinois - How to install cpvc pipe - Breakup//****//**91 9799046502 Girl & BoY love problem solution specialist molvi ji - David sedaris me talk pretty one day summary - Finding nemo movie worksheet - PEDS REVIEW - Angle between polarizer and analyzer - Qualitrol sudden pressure relay 900 - Tax - A disadvantage of flextime plans is that they often - Agno3 nh4oh - The human person in the environment - Https coolclimate berkeley edu calculator - Are surds real numbers - A good man cannot be harmed socrates - Article Review - Urban geography lesson plans - What are hieroglyphics 1 point - Photosynthesis light dependent reaction diagram - Adding and subtracting algebraic fractions with unlike denominators - Statistical studies statistical investigations student activity sheet 1 - Meridian 1 option 11c - Jo koy ex wife jennifer santillan - Cultural activity report - Sam cengage project answers 2016 - Sjsu graduate acceptance rate - Magnesium and hydrocloric acid - Arduino fire alarm system pdf - The winslow boy 1948 cast - Bid response proposal - Tele-health - Diploma of electrical engineering tafe nsw - Set 5 cheat sheet - Chiptopia 2018 - English - Market structure assignment - Apply 3.1 - Middlestone moor primary school - Rhetorical analysis outline worksheet - Prince william education association - Research paper - Due Tonight by 11 pm - Physics for scientists and engineers 6th edition solutions tipler - Project pro cement mixer 74109 - María se casó después de graduarse. - What are the characteristics of hazardous manual tasks - Rain man doctor scene - 150w pure sine inverter - Discussion - Cwa 4.4 origins of the vietnam war quiz answers - Picot paper example - Cherry pink and apple blossom white musical ideas - What role does balance play in daoist teachings - List of management accounting techniques - Roll of thunder hear my cry characters pictures - Sample well woman soap note - Principle of business management , 3 questions, APA STYLE - Best sunscreen for sunscreen allergy - 6-8 pages paper - Chief joseph i will fight no more forever speech - Project Week 1 10/28/2020 - EH Week7 DB - The world on the turtle's back - Wendy and peter pan script - The basic practice of statistics pdf - Adler v george 1964 - Global project