Question

In: Computer Science

Create an example schema representing Edgar Rice Burroughs published works starting with him as an author...

Create an example schema representing Edgar Rice Burroughs published works starting with him as an author and representing most of the metadata present in the following site/list of books.

http://www.gutenberg.org/ebooks/author/48 (Links to an external site.)

You need to include 5 books in your example schemas.

Create a JSON schema representing 5 of an author (Edgar Rice Burroughs) works.

Solutions

Expert Solution

{
  "books": [
    {
      "author": "Burroughs, Edgar Rice, 1875-1950",
      "title": "A Princess of Mars",
      "language": "English",
      "locclass": "PS: Language and Literatures: American and Canadian literature",
      "subject": "Science fiction",
      "category": "Text",
      "ebookno.": 62,
      "releasedate": "Apr 1, 1993",
      "copyright": "Public domain in the USA.",
      "price": "$0.00"
    },
    {
       "author": "Burroughs, Edgar Rice, 1875-1950", "title": "Tarzan of the Apes", "language": "English", "locclass": "PS: Language and Literatures: American and Canadian literature", "subject": "Tarzan (Fictitious character) -- Fiction", "category": "Text",
"ebookno": 78,
"releasedate": "Aug 1, 1993",
"copyright": "Public domain in the USA.",
"price": "$0.00"
    },
    {
      "author": "Burroughs, Edgar Rice, 1875-1950", "title": "Warlord of Mars", "language": "English", "locclass": "PS: Language and Literatures: American and Canadian literature", "subject": "Science fiction", "category": "Text",
"ebookno": 68,
"releasedate": "Jun 1, 1993",
"copyright": "Public domain in the USA.",
"price": "$0.00"
    },
    {
       "author": "Burroughs, Edgar Rice, 1875-1950", "title": "The Gods of Mars", "language": "English", "locclass": "PS: Language and Literatures: American and Canadian literature", "subject": "Science fiction", "category": "Text",
"ebookno": 64,
"releasedate": "May 1, 1993",
"copyright": "Public domain in the USA.",
"price": "$0.00"
    },
    {
       "author": "Burroughs, Edgar Rice, 1875-1950", "title": "The Return of Tarzan", "language": "English", "locclass": "PZ: Language and Literatures: Juvenile belles lettres", "subject": "Tarzan (Fictitious character) -- Fiction", "category": "Text",
"ebookno": 81,
"releasedate": "Sep 1, 1993",
"copyright": "Public domain in the USA.",
"price": "$0.00"
    }
  ]
}

Related Solutions

• Relational Schema Create a relational database schema consisting of the four relation schemas representing various...
• Relational Schema Create a relational database schema consisting of the four relation schemas representing various entities recorded by a furniture company.   Write CREATE TABLE statements for the following four relation schemas. Define all necessary attributes, domains, and primary and foreign keys. Customer(CustomerID, Name, Address) FullOrder(OrderID, OrderDate, CustomerID) Request(OrderID, ProductID, Quantity) Product(ProductID, Description, Finish, Price) You should assume the following: Each CustomerID is a number with at most three digits, each OrderID is a number with at most five digits,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT