BADM352 Assignment 1: Relational Database Design

You can draw the diagrams on the paper and take pictures just make sure the picture is clear. No form of presentation will be favored over others.

1. Walmart

The local Walmart store is upgrading its legacy database system. The new database system will be used to manage the supply chain and transactional data, including products, vendors,customersandinvoices.Designarelationaldatabasemodelfor this system. Someofthebusinessrulesareasfollows:Aproductcanhavemanyvendors, and a vendor can supply many products. A customer can have many invoices, and each invoice is associated with only one customer. Each invoice may contain many different products, and a product can appear on many invoices (For example, a TV model can be purchased by many customers and therefore appears on multiple invoices).

1. Start with the Entity-Relationship Model.List all entities, attributes, and relationships among entities.

2. Draw the relational model.

2. MTD

Champaign Urbana Mass Transit District (MTD) provides public transportation to the citiesofChampaign,Urbana,Savoy,andtheUniversityofIllinois.Beingintheservice industry, MTD relies heavily on feedback and complaints through their customers to give the best transportation service possible. Recently, MTD planned to create an electronic complaint system that allows customers to file complaints about its services. Design a relational database model for this system. Some of the business rules are as follows: An MTD route offers multiple rides (for example, Route 100 yellow offers multiple rides from 6:00 am to the midnight on weekdays).Each route has many stops, and one stop maybe shared by many different routes. Each ride has a unique number and is operated by one driver.A driver is assigned to many rides,and a ride is driven by different drivers based on the shift schedule.The system allows a customer to file a complaint for a particular ride.

1. StartwithEntity-RelationshipModel.Listallentities,attributes,andrelationshipsamong entities.

2. Draw the relational model.

3. IMDB

The Internet Movie Database (IMDb) is an online database of information related to films and television shows including cast, production crew, biographies, plot summaries, and reviews.Design relational database model for IMDB.Your design should contain the basic entities such as Movie and Actor,but you are also welcome to extend your design by considering more entities such as Genre, User, Review, TV shows/series, or anything else you can find on IMDB.

1. StartwiththeEntity-RelationshipModel.Listallentities,attributes,andrelationships among entities.

2. Draw the relational model.