Developing a Database on Simply Credit Card

 To construct database tables and relationships, and populate that database with data. Also, to write database queries and develop database reports using the Microsoft Access or LibreOffice Base . You are supposed to build a database on Simply Credit Card and below are the instructions and attached is the word data peruse for your attention to determine the cost. *Assignment * *- “Simply Credit Card” Database* —————————— Directions In this assessment, you will construct database tables and relationships, and you will populate that database with data. You will also write database queries and develop database reports. You are required to complete this assignment using either Microsoft Access or LibreOffice Base. “Simply Credit Card” Company Scenario You have recently been hired as an IT manager at Simply Credit Card Company. This company issues credit cards for customers, and customers use credit cards at various stores. Simply Credit Card Company already has a database system; however, the database was designed about 20 years ago and has multiple issues. One of the issues is that the data is not normalized, and parts of the data have been replicated in multiple tables. One of your initial assignments, a high priority one, is to redesign the database and eliminate the issue of replication. The company’s CIO, Jim Miller, has personally entrusted you with this project. In order to establish a new database, you came up with preliminary database design. You want to construct a prototype of your database design using either Microsoft Access or LibreOffice Base before you present the design to your team members. Your database needs to keep track of customers, credit card details, sales that were made using the credit cards, and the merchants with whom the sales were placed. You arrived at the tables listed below for this scenario. You have also indicated the primary key and foreign key (where applicable) in each table. The sample data with all four tables is presented in the attached word document [image: Preview the document] . Important Note: As you progress through Module Assignment, please stick to the data types I indicated in the word document (see above). For example, please use Text data type for credit card numbers, and integers for merchant id, customer id etc. Some of you may like to use big integer (Bigint or large number) or similar data types in newer versions of MS Access for credit card numbers. But please do not use this and instead use text field for credit card numbers. Bigint data type may cause issues as you convert from one version of MS Access to another version (e.g. 2016 to 2013). PART A: Building database tables *Step 1:* If you have not already done so, you will need to acquire the database management software that is required for this project. Microsoft Access and LibreOffice Base are both approved for this IS 305 project. Check the Technical Requirements page of the Orientation module to learn more about acquiring the required software. *Step 2*: Open your database management software. Save a new database, and give it a title (e.g., infosys305). *Step 3*: Using your database management software, create the following tables: CUSTOMER table, CREDIT_CARD_ACCOUNT table, MERCHANT table, and SALE table *in that order*. Use the data types from Phase I to define each field in each table. *Step 4:* Create the Primary Key – Foreign Key (PK-FK) relationships among tables. *Step 5:* Enter data into the four tables. Add sample data of 20 rows for the CUSTOMER table, 30 rows for the CREDIT_CARD_ACCOUNT table, 15 rows for the MERCHANT table, and 60 rows for the SALE table. Add fictitious data.