What weaknesses does First Normal have?AData deletion is not possibleBRecord is incompleteCDeleting one record can delete other data

First Normal Form (1NF) is a basic level of database normalization that eliminates redundant data by grouping them into tables. However, it does have some weaknesses:

A) Data deletion is not possible: This is not a weakness of 1NF. In fact, data deletion is possible in all forms of normalization, including 1NF.

B) Record is incomplete: This can be a potential weakness in 1NF. If not all necessary data is included in the table, the record can be considered incomplete. However, this is more of a data entry issue rather than a weakness of 1NF itself.

C) Deleting one record can delete other data: This is known as deletion anomaly, which is indeed a weakness of 1NF. If a record is deleted, all information stored in that record is lost. For example, if a customer who has made multiple purchases is deleted from the "Customers" table, all purchase history of that customer would also be lost. This can be mitigated by further normalization.