Assignment Instructions<\/p>\n\n\n\n
Instructions:<\/p>\n\n\n\n
Complete the following Exercises in a Word Document (Be sure to label each question with the corresponding number) Name your Word Document Unit1Assignment2Ricks. <\/p>\n\n\n\n
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. <\/p>\n\n\n\n
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. <\/p>\n\n\n\n
3. From the above case scenario, identify the business rules and the associated constraints from the case scenario described. <\/p>\n\n\n\n
4. Identify the possible tables and associated fields from the given scenario: <\/p>\n\n\n\n
Book.com is an online virtual store on the Internet where customers can browse the catalog and select products of interest. <\/p>\n\n\n\n
\u2022 Every book has a title, ISBN, year, and price. The store also keeps the author and publisher for any book.<\/p>\n\n\n\n
\u2022 For authors, the database keeps the name, address, and the URL of their homepage.<\/p>\n\n\n\n
\u2022 For publishers, the database keeps the name, address, phone number, and the URL of their website.<\/p>\n\n\n\n
\u2022 The store has several warehouses, each of which has a code, address, and phone number.<\/p>\n\n\n\n
\u2022 The warehouse stocks several books. A book may be stocked at multiple warehouses.<\/p>\n\n\n\n
\u2022 The database records the number of copies of a book stocked at various warehouses.<\/p>\n\n\n\n
\u2022 The bookstore keeps the name, address, email-id, and phone number of its customers.<\/p>\n\n\n\n
\u2022 A customer owns several shopping carts. A shopping cart is identified by a Shopping_Cart_ID and contains several books.<\/p>\n\n\n\n
\u2022 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.<\/p>\n\n\n\n
\u2022 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. <\/p>\n\n\n\n
5. Give an example of a conceptual model and a physical model. <\/p>\n\n\n\n
6. For each entity, select the attribute that could be the unique identifier of each entity. <\/p>\n\n\n\n
Entity: STUDENT<\/p>\n\n\n\n
Attributes: student ID, first name, last name, address<\/p>\n\n\n\n
Entity: MOVIE<\/p>\n\n\n\n
Attributes: title, date released, producer, director<\/p>\n\n\n\n
Entity: LOCKER<\/p>\n\n\n\n
Attributes: size, location, number<\/p>\n\n\n\n
7. Identify the possible Entities and Attributes from the given scenario. <\/p>\n\n\n\n
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. <\/p>\n\n\n\n
8. Resolve M: M relationships between STUDENT and the COURSE and between FACULTY and the COURSE using a barred relationship. <\/p>\n\n\n\n
These three entities\u2014SONG, EVENT, and CUSTOMER\u2014play 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?<\/p>\n\n\n\n
Song<\/p>\n\n\n\n
Event<\/p>\n\n\n\n
Customer<\/p>\n\n\n\n
Title<\/p>\n\n\n\n
Description<\/p>\n\n\n\n
Venue<\/p>\n\n\n\n
First Name<\/p>\n\n\n\n
Phone Number<\/p>\n\n\n\n
Release Date<\/p>\n\n\n\n
Last Name<\/p>\n\n\n\n
Type<\/p>\n\n\n\n
Email Address<\/p>\n\n\n\n
Submit your Word document with all of the elements clearly labeled.<\/p>\n\n\n\n
Estimated time to complete: 4 hours<\/p>\n\n\n\n
References<\/p>\n\n\n\n
Overview | Oracle Academy (2022). Oracle. https:\/\/academy.oracle.com\/en\/oa-web-overview.html <\/p>\n","protected":false},"excerpt":{"rendered":"
Assignment Instructions Instructions: Complete the following Exercises in a Word Document (Be sure to label each question with the corresponding […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-12784","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"acf":[],"yoast_head":"\n