Select Page

Step 1. Place your order

Fill in the order form and provide all details of your assignment.

Step 2. Make Payment

Choose the payment system that suits you most.

Step 3. Receive your paper

Once your paper is ready, we will email it to you.

Give an example of a conceptual model and a physical model.

by | Nov 12, 2022 | Other | 0 comments

Get Help With Your Essay

"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results."

For This or a Similar Paper Click To Order Now

 

Assignment Instructions
Instructions:
Complete the following Exercises in a Word Document (Be sure to label each question with the corresponding number) Name your Word Document Unit1Assignment2Ricks.
1. ABC School District would like to create a student online information and registration system to capture student-related information. The system needs to be designed as an online process to allow all new students to register online. It should also allow existing students to update and review all information. Create a list of important data that would need to be captured and stored in the student registration database.
2. LibBook is a successful digital library that rents CDs and provides access to the Internet for browsing their repository of articles and magazines. With the growing business, LibBook needs to enhance its information system to support proposed changes to the business. LibBook attracts new members easily and the number of members is growing rapidly. The membership base is not stable, however, which is a cause for concern. The main idea is to introduce the concept of membership at LibBook. Members will pay a membership fee and initially, there will be three types of membership (corporate, student, individual) although more may be introduced later. Student membership is free. Corporate and Faculty memberships incur a fee but entitle the member to privileges. The type of membership can be changed only if sufficient justification is provided.
3. From the above case scenario, identify the business rules and the associated constraints from the case scenario described.
4. Identify the possible tables and associated fields from the given scenario:
Book.com is an online virtual store on the Internet where customers can browse the catalog and select products of interest.
• Every book has a title, ISBN, year, and price. The store also keeps the author and publisher for any book.
• For authors, the database keeps the name, address, and the URL of their homepage.
• For publishers, the database keeps the name, address, phone number, and the URL of their website.
• The store has several warehouses, each of which has a code, address, and phone number.
• The warehouse stocks several books. A book may be stocked at multiple warehouses.
• The database records the number of copies of a book stocked at various warehouses.
• The bookstore keeps the name, address, email-id, and phone number of its customers.
• A customer owns several shopping carts. A shopping cart is identified by a Shopping_Cart_ID and contains several books.
• Some shopping carts may contain more than one copy of the same book. The database records the number of copies of each book in any shopping cart.
• At that time, more information will be needed to complete the transaction. Usually, the customer will be asked to fill in or select a billing address, a shipping address, a shipping option, and payment information such as a credit card number. An email notification is sent to the customer as soon as the order is placed. List two examples of conceptual models and physical models.
5. Give an example of a conceptual model and a physical model.
6. For each entity, select the attribute that could be the unique identifier of each entity.
Entity: STUDENT
Attributes: student ID, first name, last name, address
Entity: MOVIE
Attributes: title, date released, producer, director
Entity: LOCKER
Attributes: size, location, number
7. Identify the possible Entities and Attributes from the given scenario.
A company has several departments. Each department has a supervisor and at least one employee. Employees must be assigned to at least one, but possibly more departments. At least one employee is assigned to a project, but an employee may be on vacation and not assigned to any projects. The important data fields are the names of the departments, projects, supervisors and employees, as well as the supervisor and employee number and a unique project number.
8. Resolve M: M relationships between STUDENT and the COURSE and between FACULTY and the COURSE using a barred relationship.
These three entities—SONG, EVENT, and CUSTOMER—play a role in a DJ business and are listed as the first three column headings in the table below. The fourth column contains a list of attributes. Use an X or a checkmark to indicate that the attribute could belong to one or more of the entities listed. For example, could Title be an attribute for Song, for Event, and/or for Customer?
Song
Event
Customer
Title
Description
Venue
First Name
Phone Number
Release Date
Last Name
Type
Email Address
Submit your Word document with all of the elements clearly labeled.
Estimated time to complete: 4 hours
References
Overview | Oracle Academy (2022). Oracle. https://academy.oracle.com/en/oa-web-overview.html

For This or a Similar Paper Click To Order Now

Affordable

Only pay once! Clear pricing system with no hidden fees, direct line to your writer, 24/7 customer support.

Quality

Our reputation is built on delivering top-quality papers. No matter how small the task, we give customers our best.

Timely

Missed due dates can result in a serious loss of marks. We strive to finish everything with time to spare.