What is an online database?

  

Pickan online database
and then describe entities and attributes that the online database must track.
Diagram the relationship between entities that you have identified.
3 pages
Week 3 Assignment
Prepare a 2- or 3-page paper for this assignment.
Pick an online database and then describe entities and attributes that the online database must
track. Diagram the relationship between entities that you have identified.
Some examples of online database include the following:

Website for searching past and current movies
Website for music titles
Website for drug, supplement, and herbal information
Website for car resale information
Website for any other data
Tracking Customer Usage Diagram
Tracking Customers and Orders Diagram
This is tracking the customers buying habits, products ordered, geographical location of customer and
shipment deliveries.
Pick one you would like to do, it dont matter to me, if you want to do it on something else thats okay
with me, just do the magic you do all the time. I have to put in a diagram into the assignment so if you
need help with that let me know, I will help.
Tony

Don't use plagiarized sources. Get Your Custom Essay on
What is an online database?
Just from $13/Page
Order Essay

Introduction:
Online databases have become an essential aspect of various industries and sectors. These databases allow organizations to track and manage data efficiently and effectively. In this assignment, we will explore the entities and attributes required for an online database and the relationship between them. The focus will be on one of the online databases, such as the Website for searching past and current movies, Website for music titles, Website for drug, supplement, and herbal information or website for car resale information.

Description:
For this assignment, we will consider the online database for tracking customer usage. The entities that the online database must track include customers, products, orders, and shipments. Each entity has specific attributes that must be tracked. For instance, the customer entity will have attributes such as name, address, email address, and phone number. The product entity will include attributes such as product name, manufacturer, and price. The order entity will contain attributes such as order date, order number, and payment method, whereas geographic location and delivery information will be attributes of the shipment entity.

The relationship between these entities is critical for the efficient management of the online database. As per the diagram, the database will maintain a one-to-many relationship between customer and order entities. That means one customer can have multiple orders, but each order can be associated with only one customer entity. Similarly, each order entity can be associated with multiple product entities, but each product can be associated with only one order entity. The shipment entity will have a one-to-one relationship with the order entity, meaning one order can have only one shipment entity and each shipment entity is directly related to one order entity.

To conclude, the online database for tracking customer usage must include entities such as customers, products, orders, and shipments. Each entity will have several attributes, and the relationship between these entities is essential to manage data effectively. The diagram of the relationship between entities will help visualize this relationship more efficiently and effectively.

Objectives:
– To understand the concept of online databases
– To identify entities and attributes that must be tracked in an online database
– To illustrate the relationship between entities in an online database through a diagram

Learning Outcomes:
– After completing this assignment, students will be able to explain the purpose of an online database and its importance in various fields
– Students will be able to identify and describe entities and attributes that an online database must track, and the inter-relationship among them
– Students will be able to create a clear and concise diagram of the entities and their relationships in an online database

Entities and Attributes for a Car Resale Online database:
– Entities: Customers, Cars, Dealerships, Sales Transactions, Financing Options
– Attributes:
– Customers: Name, Address, Email, Phone Number, Credit Score
– Cars: Make, Model, Mileage, Year, Condition, VIN Number
– Dealerships: Name, Address, Phone Number, Website
– Sales Transactions: Sale Date, Purchase Price, Customer ID, Car ID, Payment Method
– Financing Options: Monthly Payment, Interest Rate, Loan Amount, Down Payment

Relationship Diagram:
(one) (one)
Customer — Transactions — Car
(many) (many)

Explanation:
– Each customer can make multiple transactions, and each transaction corresponds to one car
– Each car can be involved in multiple transactions with different customers

Tracking Customer Usage Diagram:
Entities: Users, Pages, Time Spent
Attributes:
– Users: Name, Email, Login Credentials
– Pages: URL, Content, Time of Access
– Time Spent: Duration, Frequency

Relationship Diagram:
(many)
Users —- Page
|
| (many)
——- Time Spent

Explanation:
– Each user can access multiple pages with different frequency and duration
– Each page can be accessed by multiple users
– Time spent is a relationship between the user and the page, where each time spent corresponds to one user-page combination.

Tracking Customers and Orders Diagram:
Entities: Customers, Products, Orders
Attributes:
– Customers: Name, Email, Address, Phone Number
– Products: Product Name, Description, Price, Quantity Available
– Orders: Order Number, Date, Customer Name, Product Name, Quantity Ordered

Relationship Diagram:
(one) (many)
Customers — Orders — Products
(many) (many)

Explanation:
– Each customer can have multiple orders
– Each order can contain multiple products
– Multiple customers can order the same product
– The relationship between the customer and the order is one-to-many.
– The relationship between the order and the product is also one-to-many.

Solution 1: Online Database for Music Titles

Entities:
1. Artist: This entity will track information about the artist, including their name, biography, and photo.
Attributes: Name, Biography, Photo, Genre, Albums, Songs.

2. Album: This entity will track information about the albums, including the title, cover image, release date, and list of songs.
Attributes: Title, Cover Image, Release Date, Genre, Songs.

3. Song: This entity will track information about the individual songs, including the title, artist, album, duration, and lyrics.
Attributes: Title, Artist, Album, Duration, Lyrics.

Relationship between Entities:
The Artist entity has a one-to-many relationship with the Album entity since an artist can have multiple albums. The Album entity has a one-to-many relationship with the Song entity since an album can have multiple songs.

Diagram:
Artist —< Album ---< Song Solution 2: Online Database for Car Resale Information Entities: 1. Car: This entity will track information about the car, including the make, model, year, color, and mileage. Attributes: Make, Model, Year, Color, Mileage, VIN, Condition. 2. Owner: This entity will track information about the car owner, including their name, address, and contact information. Attributes: Name, Address, Phone, Email. 3. Dealer: This entity will track information about the car dealership, including their name, address, and contact information. Attributes: Name, Address, Phone, Email. 4. Sale: This entity will track information about the sale of the car, including the buyer, seller, price, and date of sale. Attributes: Buyer, Seller, Price, Date of Sale. Relationship between Entities: The Car entity has a one-to-one relationship with the Owner entity since each car can only have one owner. The Car entity has a one-to-many relationship with the Sale entity since a car can be sold multiple times. The Sale entity has a many-to-one relationship with the Dealer entity since a dealer can sell multiple cars. Diagram: Car ---< Owner Car ---< Sale >— Dealer

Suggested Resources/Books:
1. Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design by Michael J. Hernandez
2. Fundamentals of Database Systems by Ramez Elmasri and Shamkant B. Navathe
3. Database System Concepts by Abraham Silberschatz, Henry F. Korth, and S. Sudarshan

Similar Asked Questions:
1. What entities and attributes should be tracked in an online database for e-commerce?
2. How does the relationship between the entities affect the design of the online database?
3. What are the common challenges faced while designing an online database?
4. How can data integrity and security be ensured in an online database?
5. What are the different types of relationships that can exist between entities in an online database?

Entities and Attributes for an Online Movie Database

Entities:
1. Movie: Basic details of the movie such as title, summary, release date, genre, director, actors, etc.
2. Review: User reviews and ratings of the movie.
3. User: Basic details of the user such as name, email, password, location, etc.

Attributes:
1. Movie: Title (varchar), Summary (text), Release Date (date), Genre (varchar), Director (varchar), Actors (varchar), Rating (float), etc.
2. Review: Movie ID (int), User ID (int), Rating (float), Comment (text), etc.
3. User: Name (varchar), Email (varchar), Password (varchar), Location (varchar), etc.

Relationship between Entities:
One movie can have multiple reviews and one review can be given by one user. Therefore, the relationship between Movie and Review is One-to-Many. One user can give multiple reviews and one review can be given by only one user. Therefore, the relationship between User and Review is One-to-Many.

Diagram:
Movie (1) <----- (many) Review User (1) <----- (many) Review

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
× How can I help you?