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

B1681 pats transceiver fault - What do biological oceanographers do - Masinde muliro university of science & technology - American government - Case Study Analysis 1 - Palliative care - Enron the smartest guys in the room stream - Case Study - The manager of weiser is given a bonus - Https searchsqlserver techtarget com definition database - Judith lorber believing is seeing - Human sexuality diversity in contemporary america 9th edition free pdf - Todd harbaugh net worth - The mousetrap character analysis - Strategic groups beer industry - Agl new connections ewr - Danfoss plus 1 guide - Nursing initial assessment form - SCIENCE Discussion(NO PLAGIARISM, A++ WORK, QUALITY, On time) - Csis 100 liberty university - ART style guide 2 - Maxine hong kingston tongue tied - Mary kay products in india - Ngpf question of the day - Due Friday by 3 pm - Compute worley's customer margin for university and memorial - Do metals tend to form positive ions - Communication skills in pharmacy - Chase bank bissonnet hwy 6 - Year 10 physics notes - Hesta super rollover form - Carta continuous adaptive risk and trust - Blue ease cream holland barrett - 2 PAGES ESSAY - Dnv 2.7 1 padeye calculation - Master budget template excel - Week 3 - Assignment: Evaluate Data Storage Systems - Square root of 1/12 - Closing medical practice checklist - Portifolio - Steve biko academic hospital occupational therapy pretoria - Woodlands boarding kennels rochdale - Target corporation case study pdf - Types of organizational interventions - Assignment - Shelly cashman excel 2016 module 3 sam project 1a - Cotton cushion hs code - Business Intelligence - Fronius inverter wifi setup - Midi file format in multimedia - Cisco camera control cable - Short essay about a Bollywood movie - Fierce conversations discussion questions - Event tree analysis fire - How to demonstrate a tornado - How did matisse die - Journal Article Summaries/Evaluation - Wch lottery draw date - How to calculate drg reimbursement - Can c&h recover the liquidated damages from sun ship - Marie louise house romsey - Cisco application visibility and control - Icandy peach adjust angle - The zoom slider is located on the ____ - Year 11 legal studies practice exam - Organic qualitative analysis flow chart - Pastel de chocolate ser para lucía - Monash marketing course map - Week 1 Lecture Video and Homework - Case study - Gc 6 isopropyl alcohol - Nutriwater - Intel corp bring your own device case analysis - Boiler and pressure vessel act - English composition - Fall of humanity then and now worksheet - Taelln411 answers - Author of a fine balance - Surface area of a cylinder sector - Piper alpha disaster summary - Accounting discussion - Case study analysis example - Dbm 380 week 4 database creation - How to create an ecomap in word - Penn foster written communication exam answers - What is the simple past tense of grow - ?? same-day +27833173182 HARARE" ABORTION CLINIC // PILLS,,,, - The technical designer focuses on how data should be stored in a decision support system (dss). - Entry notice form 9 - Bus - Adler v george 1964 - Moneysmart fun day out - Sas tactical mt gravatt - Percentage of acetic acid in vinegar lab answers - Rachel mcdowall street dance - Does the excretory system show that the earthworm is segmented - 3d brain model clay - Nuffield academy online kallidus 1 - Goal setting influences employee behavior and performance mainly by improving: - What is the exact speed of light