Category: Databases

I’m e-commerce student. I’m training in IT support department.I want to write second periodic report. I want it include more about cybersecurity. I will attach the first report.
and this is responsibilities I should learn
1. Identify and fix technical problems that may
have an impact on the operation, user experience,
and transactions of websites.
2. Cybersecurity procedures.
3. Software management, which includes customer
support platforms and content management
systems.
4. User support and communication.
5. Maintenance of networks and systems.

Do your own research on 5 or more distinct database models that are reported to be most popular (excluding Multi-modal) on . Go deeper in your comparative research using other up-to-date information you can find on the web beyond the summary descriptions provided on the above website. Finally, put together and submit your own pros/cons comparison table that can guide you in selecting the best database model given a specific database application in the future. Attached will be a word doc of how the hw should be please use the same 5 database in the world doc and add more research , compared them pro and cons of each

I’m e-commerce student. I’m training in IT support department.I want to write second periodic report. I want it include more about cybersecurity. I will attach the first report.
and this is responsibilities I should learn
1. Identify and fix technical problems that may
have an impact on the operation, user experience,
and transactions of websites.
2. Cybersecurity procedures.
3. Software management, which includes customer
support platforms and content management
systems.
4. User support and communication.
5. Maintenance of networks and systems.

I’m e-commerce student. I’m training in IT support department.I want to write second periodic report. I want it include more about cybersecurity. I will attach the first report.
and this is responsibilities I should learn
1. Identify and fix technical problems that may
have an impact on the operation, user experience,
and transactions of websites.
2. Cybersecurity procedures.
3. Software management, which includes customer
support platforms and content management
systems.
4. User support and communication.
5. Maintenance of networks and systems.

I’m e-commerce student. I’m training in IT support department.I want to write second periodic report. I want it include more about cybersecurity. I will attach the first report.
and this is responsibilities I should learn
1. Identify and fix technical problems that may
have an impact on the operation, user experience,
and transactions of websites.
2. Cybersecurity procedures.
3. Software management, which includes customer
support platforms and content management
systems.
4. User support and communication.
5. Maintenance of networks and systems.

I’m e-commerce student. I’m training in IT support department.I want to write second periodic report. I want it include more about cybersecurity. I will attach the first report.
and this is responsibilities I should learn
1. Identify and fix technical problems that may
have an impact on the operation, user experience,
and transactions of websites.
2. Cybersecurity procedures.
3. Software management, which includes customer
support platforms and content management
systems.
4. User support and communication.
5. Maintenance of networks and systems.

1. Describe what a database is?
2. Discuss the main characteristics of the datab

1. Describe what a database is?
2. Discuss the main characteristics of the database approach and how it differs from traditional file systems. Discuss the differences between database systems and information retrieval. A minimum of 1 reference from the online textbook (attached in PDF) is required, along with APA formatting.

Answer the following
17.18 – Consider a disk with block size B=512 bytes. A blo

Answer the following
17.18 – Consider a disk with block size B=512 bytes. A block pointer is P=6 bytes long, and a record pointer is P R =7 bytes long. A file has r=30,000 EMPLOYEE records of fixed-length. Each record has the following fields: NAME (30 bytes), SSN (9 bytes), DEPARTMENTCODE (9 bytes), ADDRESS (40 bytes), PHONE (9 bytes), BIRTHDATE (8 bytes), SEX (1 byte), JOBCODE (4 bytes), SALARY (4 bytes, real number). An additional byte is used as a deletion marker.
Calculate the record size R in bytes.
Calculate the blocking factor bfr and the number of file blocks b assuming an unspanned organization.
Suppose the file is ordered by the key field SSN and we want to construct a primary index on SSN. Calculate (i) the index blocking factor bfr i (which is also the index fan-out fo); (ii) the number of first-level index entries and the number of first-level index blocks; (iii) the number of levels needed if we make it into a multi-level index; (iv) the total number of blocks required by the multi-level index; and (v) the number of block accesses needed to search for and retrieve a record from the file–given its SSN value–using the primary index.
Suppose the file is not ordered by the key field SSN and we want to construct a secondary index on SSN. Repeat the previous exercise (part c) for the secondary index and compare with the primary index.
Suppose the file is not ordered by the non-key field DEPARTMENTCODE and we want to construct a secondary index on SSN using Option 3 of Section 18.1.3, with an extra
Suppose the file is ordered by the non-key field DEPARTMENTCODE and we want to construct a clustering index on DEPARTMENTCODE that uses block anchors (every new value of DEPARTMENTCODE starts at the beginning of a new block). Assume there are 1000 distinct values of DEPARTMENTCODE, and that the EMPLOYEE records are evenly distributed among these values. Calculate (i) the index blocking factor bfr i (which is also the index fan-out fo); (ii) the number of first-level index entries and the number of first-level index blocks; (iii) the number of levels needed if we make it a multi-level index; (iv) the total number of blocks required by the multi-level index; and (v) the number of block accesses needed to search for and retrieve all records in the file having a specific DEPARTMENTCODE value using the clustering index (assume that multiple blocks in a cluster are either contiguous or linked by pointers).
Suppose the file is not ordered by the key field Ssn and we want to construct a B + – tree
level of indirection that stores record pointers. Assume there are 1000 distinct values of DEPARTMENTCODE, and that the EMPLOYEE records are evenly distributed among these values. Calculate (i) the index blocking factor bfr i (which is also the index fan-out fo); (ii) the number of blocks needed by the level of indirection that stores record pointers; (iii) the number of first-level index entries and the number of first-level index blocks; (iv) the number of levels needed if we make it a
multi-level index; (v) the total number of blocks required by the multi-level index and the blocks used in the extra level of indirection; and (vi) the approximate
number of block accesses needed to search for and retrieve all records in the file having a specific DEPARTMENTCODE value using the index.
access structure (index) on SSN. Calculate (i) the orders p and p leaf of the B + -tree; (ii) the number of leaf-level blocks needed if blocks are approximately 69% full (rounded up for convenience); (iii) the number of levels needed if internal nodes are also 69% full (rounded up for convenience); (iv) the total number of blocks required by the B + -tree; and (v) the number of block accesses needed to search for and retrieve a record from the file–given its SSN value– using the B + -tree.
17.19 – A PARTS file with Part# as key field includes records with the following Part# values:
23, 65, 37, 60, 46, 92, 48, 71, 56, 59, 18, 21, 10, 74, 78, 15, 16, 20, 24, 28, 39, 43, 47, 50,
69, 75, 8, 49, 33, 38. Suppose the search field values are inserted in the given order in a B + -tree of order p=4 and p leaf =3; show how the tree will expand and what the final tree looks like.

It has to be an 8 page paper, with 10 references. It can be on any of these topi

It has to be an 8 page paper, with 10 references. It can be on any of these topics:
Anonymization/Pseudonymization, Data Hiding, Metadata and Security, XML Security, Authorization and Access Control, Data Integrity, Privacy Preserving Data Mining, Statistical Database Security, Control of Data Disclosure, Private Information Retrieval, Secure Stream Processing, Secure Auditing, Data Retention, Search on Encrypted Data, Digital and Enterprise Rights Management, Multimedia Security and Privacy, Private Authentication, Identity Management, Privacy Enhancing Technologies, Security and Semantic Web, Security and Privacy in Ubiquitous Computing, Security and Privacy of Health Data, Web Service Security, Trust Management, Policy Management, Applied Cryptography
APA style format

Use the Image attached below to answer the questions. (these are two different m

Use the Image attached below to answer the questions. (these are two different modules so please provide the answers seperately) so it is easy for me to turn in.
1st.
Individually, using the physical ER model, write the SQL to create the database. Share your physical ER model and the SQL with the group. The SQL should
Create the database
Tables with all columns
Primary and foreign keys
Any unique constrain
——————————————————————————————————————–
2nd question.
Individually, write the SQL to insert the sample data from Module 1.
Identify hypothetical scenarios that would require updates and deletes on your records and write SQL appropriately. For example: phone number for a contact changes; someone is no longer your contact.