2023 Summer 8410 Assignment 3b (2)

pdf

School

Lone Star College System, Woodlands *

*We aren’t endorsed by this school

Course

1301

Subject

Computer Science

Date

Dec 6, 2023

Type

pdf

Pages

3

Uploaded by juliedonaka

Report
-1- ASSIGNMENT #3b – Database Design and Implementation ISQA 8410 Summer 2023 Part 3b Due: Wednesday, August 2 (extra credit may be submitted up to Friday, August 11, after the final exam). Overview In this continuation of assignment 3, you will practice database design. You have worked through a number of normalization problems. You will now apply principles of database design to transform the GlobalGiving ER diagram into an Oracle schema. Tasks Task 2 – From E-R Diagram to Relational Schema 1. Convert the provided data model 1 ( GlobalGiving A3b.pdf ), based on Assignment #2 into a detailed logical data model. 2. Convert the logical data model into a relational schema. 3. Make sure that all of your tables are fully normalized through BCNF (Note: Keep in mind the business rules from Assignment 2, and pay close attention to the implications of identifying relationships…) 4. (x-credit: up to 15 pts) Implement the tables in Oracle and add at least two rows of data to each table. For Step (1), you will do things like provide a primary key for any entity that is missing one, transform many-to-many relationships into an associative entity, etc. In the data model I’m giving you, attributes with plural names are multivalued (hint). Step (2) will involve renaming columns in the physical data model so that they are more suitable for column names, and defining primary key, referential integrity, UNIQUE, and/or NOT NULL constraints. For this assignment, I am not requiring that you define or use domains or data types. For the extra credit, you’ll need to address these issues. 1 I have modified a few of the business rules from assignment 2 to make this data model better for the purposes of assignment 3b. Don’t look for absolute consistency. In particular, an account holder is now limited to creating a single fundraiser, and a project can be associated with multiple themes and with multiple project recognition badges.
-2- Step (3) is not something the tool can help you with. You may also normalize after Step (1) if you prefer. You may use either a top-down approach, a bottom-up approach, or a hybrid approach. It is up to you. Whichever way you choose to handle normalization, your outcome will be (we hope) a set of well-defined tables. If you are not using a data modeling tool, please define your relational schema using SQL CREATE TABLE statements (although you may leave out your data types, if you wish), being sure to specify any NOT NULL, UNIQUE, PRIMARY KEY, or FOREIGN KEY constraints. You do not need to specify CHECK constraints (to keep it simpler). If you are using a data modeling tool, you may simply provide a snapshot of the relational model (physical model) created by that tool. Extra Credit (10%) – Implementation Create the database Create a collection of tables in Oracle that conform to the relational schema. Include any domain integrity constraints, referential integrity, etc. Populate the database Add some data (at least two rows in each table), using data found on the screen shots in Assignment 2 or from the GlobalGiving.com website itself. To Hand In 1. Your relational schema (Task 2) 2. You may turn in your extra credit portion any time through Friday, August 11. Grading Your grade will be computed in the following way: Item Fraction of grade Task 1 70% Task 2: From E-R Diagram to Relational Schema 25% Assignment 3 reflection 5% Implementation (x-credit) 10%
-3-
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

Midterm1-Prep-solutions.pdf
Lab Activity 07 - Batch File_v2.docx
Lab Assignment 15 (1).docx
Lab Assignment 2_2023FA81814.docx
Lab Assignment 11.docx
Lab Assignment 9.docx
CSE 240 Introduction to Programming Languages Assignment 1 Unix.docx
Testout.docx
MCCG240 - Coding Scenario – Mock Exam Training Week 4 Laura Engel.docx
15.4.8.docx
3.4.6.docx
11.10.2.docx
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SEE MORE TEXTBOOKS